Update Error

Results 1 to 2 of 2

Thread: Update Error

  1. #1
    Join Date
    Dec 1969

    Default Update Error

    Why am I getting this message using UPDATE?<BR><BR>ADODB.Recordset error &#039;800a0cb3&#039; <BR><BR>Object or provider is not capable of performing requested operation. <BR><BR>Here is the code. Any help?<BR><BR>Set objConn = Server.CreateObject("ADODB.Connection") <BR> objConn.ConnectionString = "DBQ=" & DBName & ";Driver={Microsoft Access Driver (*.mdb)};"<BR> objConn.Open<BR> Set objRS = Server.CreateObject("ADODB.Recordset")<BR><BR> strSQL = "SELECT * FROM members WHERE [username]=&#039;" & username & "&#039; and [password]= &#039;" & password &"&#039;;"<BR><BR>Set objRS= objConn.execute(strSQL) <BR>objrs.movefirst<BR><BR>response.write objrs("username")<BR><BR>objrs.fields("username") = request.form("username")<BR>objrs.fields("email") = request.form("email")<BR>objrs.fields("password") = request.form("password")<BR>objrs.fields("state") = request.form("state")<BR>objrs.fields("zipcode") = request.form("zipcode")<BR>objrs.fields("datte") = request.form("datte")<BR>objrs.update<BR><BR>Respo nse.write "Update Complete"<BR>

  2. #2
    Join Date
    Dec 1969

    Default because you have a forward-only cursor

    either update with a SQL UPDATE statement, which is *FAR* more efficient, or explicitly open the recordset with<BR><BR>objrs.open strSQL, objConn, adOpenDynamic, adLockOptimistic, adCmdText<BR><BR>(don&#039;t forget to include adovbs.inc or the typelib)<BR><BR>j

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts