Error in row on add/update?

Results 1 to 3 of 3

Thread: Error in row on add/update?

  1. #1
    Join Date
    Dec 1969

    Default Error in row on add/update?

    Getting an "error in row" error when adding new record? Any ideas? <BR>Error is on objrs.update line<BR>Dim objRS<BR> Set objRS = Server.CreateObject("ADODB.Recordset")<BR> objRS.CursorLocation = adUseServer<BR> objRS.CursorType = adOpenKeySet<BR> objRS.LockType = adLockPessimistic<BR> <BR> objRS.Open "tblContacts", objConn, , , adCmdTable<BR> objRS.AddNew<BR> objRS("Address")=Request.Form("Address")<BR> objRS("City")=Request.Form("City")<BR> objRS("State")=Request.Form("State")<BR> objRS("Zip")=Request.Form("Zip")<BR> objRS.Update &#060;&#060;&#060;&#060; Errors right here &#062;&#062;&#062;&#062;<BR> <BR> ObjRS.Close<BR> Set ObjRS = Nothing<BR> <BR> Response.Redirect<BR>

  2. #2
    Join Date
    Dec 1969

    Default Bad doublepost!

    Try changing your cursor type, or using an UPDATE statement and leaving the cursor alone... If I remember correctly, the method youre using to add a recordset works for client side cursors and batch updates only... <BR><BR>A shot in the dark

  3. #3
    Join Date
    Dec 1969

    Default BronxBomber is ON patrol!

    BUSTED<BR><BR><BR>Do not pass Go<BR><BR><BR>DO NOT collect $200

Posting Permissions

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