skip to content »

800a0cb3 current recordset does not support updating

The expansion saw not only the construction of the chapel, but also the Tuesday Market Place, which is still the primary marketplace in the town today.

This may be a limitation of the provider, or of the selected locktype.These predominately feature heads; for instance, S-02 is the head of Edward the Black Prince.The church is a Grade I listed building.) was constructed around 1200, during the expansion of Lynn by Bishop William Turbus, the third Bishop of Norwich./devag/new Proj Save.asp, line 321 sql OCF = "SELECT * FROM DA_Other CFacilities" set rst OCF = Create Object("ADODB. Open sql OCF, "Provider=SQLOLEDB.1; Persist Security Info=False; User ID=sa;[email protected]; Initial Catalog=GIS; Data Source=",1,1 'x = 1 For i = 1 to (T-1) If request.form("Name" & i) "" Then **line 321 rst OCF.addnew rst OCF("Proj Id") = rsid("Proj ID") rst OCF("Fin Id") = rs Fid("ID") rst OCF("IName") = request.form("Name" & x) rst OCF("Acc Type") = request.form("AType" & x) rst OCF("Acc No") = request.form("ANo" & x) rst OCF.updatebatch End If 'x = x 1 Next Any help and/or suggestions highly appreciated. Recordset error '800a0cb3' My comments will be interspersed with your text, so make sure you read through to the end.Hopefully you won't get defensive and think I'm denigrating your abilities: no matter how it appears, everything that follows should be considered constructive criticism. Well, I would consider this to be a blessing in disguise: recordsets should not be used for updating in ASP apps. Query String("actionvar") dsn_name = "access_Development" s DSNDir = Server. Open connectstr 'create recordset Set o Rs = Server. Add New SQLstmt = "INSERT INTO tbl Biographical Data (Last Name, First Name, MI, Title, Address1, Address2, City, State, Zip, Country, Email, Phone, Bus Phone, Bus Fax, Cell Phone, Notes) VALUES('Last Name', 'First Name', 'MI', 'Title', 'Address1', 'Address2', 'City', 'State', 'Zip', 'Country', 'Email', 'Phone', 'Bus Phone', 'Bus Fax', 'Cell Phone', 'Notes')" o Conn.

Here's the code: [Code] Dim o Conn Dim o Rs Dim qry, connectstr, s DSNDir Dim dsn_name, Avtionvar Dim SQLstmt Dim Note Field, Note, o Rs_num Rows Actionvar=Request. Open "tbl Biographical Data", connectstr IF Actionvar="add" THEN o Rs.

Guard that sa account as if your job depended on it: it probably does ...

and don't try and give me the excuse that this is a development machine accessible only to you: good security practices start at the development stage.

You are currently viewing the SQL Server ASP section of the Wrox Programmer to Programmer discussions.

This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. I'm recieving the following error message when I'm trying to delete a record from a SQL table using ASP: ADODB.

I tried to modify the field in my ASP page, and it yields the following error: I tried to use ad Lock Optimistic as follows, but still not working obj RS.