'.update' is causing Syntax errors

Results 1 to 2 of 2

Thread: '.update' is causing Syntax errors

  1. #1
    Jason Guest

    Default '.update' is causing Syntax errors

    Set objRS = Server.CreateObject("ADODB.Recordset")<BR>objRS.Op en strSQL, objDataConn, ,adLockOptimistic<BR>objRS("Value") = Request.Form("SomeValue")<BR>objRS.Update<BR><BR>T he above structure comes back with "Syntax error in UPDATE statement" With the .Update method I&#039m not creating any SQL, so how do I find out where the error is? Is there a way to print the SQL to the screen somehow through the .Update method?<BR>As it is, I have nothing to check...<BR><BR>

  2. #2
    Suganraj Guest

    Default RE: '.update' is causing Syntax errors

    use Response.write(strSQL) to print the SQL statement in the window so that you can easily find. <BR><BR>Happy debugging<BR>Sugan

Posting Permissions

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