Error in update

Results 1 to 3 of 3

Thread: Error in update

  1. #1
    Join Date
    Dec 1969
    Posts
    1,315

    Default Error in update

    I am trying to update a database, using DSN less connection.<BR>Here the code:<BR><BR>dim objRS<BR>Set objRS = Server.CreateObject("ADODB.Recordset")<BR>objRS.Fi lter = "id=" & intTitleID<BR>objRS.Open "Table1", objConn, adOpenKeyset, adLockOptimistic, adCmdTable<BR>objRS("Title") = strTitle<BR>objRS("Highlight") = strHighlight<BR><BR>and the error:<BR>Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.<BR>/sysconfigdb/newsreleases/edit_go.asp, line 29<BR><BR>which is the line objRS.Open "Table1", objConn, adOpenKeyset, adLockOptimistic, adCmdTable<BR><BR>Any ideas?

  2. #2
    Big Al Guest

    Default RE: Error in update

    I take from this that you allready have the DB connectio up and running hich is called objconn, It looks like a problem with your locking.. try taking off the line. "adOpenKeyset, adLockOptimistic, adCmdTable" and then it will work. but you could get problems with two records being updated at the same time. try adding just adlockoptimistic..<BR>

  3. #3
    Join Date
    Dec 1969
    Posts
    1,315

    Default RE: Error in update

    The variable that I &#039ve tried to use the filter was empty!!!<BR>Thanks.

Posting Permissions

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