sql update statement

Results 1 to 2 of 2

Thread: sql update statement

  1. #1
    Join Date
    Dec 1969

    Default sql update statement

    I just changed the driver to my databases in my scripts to jet oledb because of the temporary volatile error. In the same script there is a syntax error in the sql statement to update my database. I can&#039;t seem to find it.<BR><BR>SQL_query = "UPDATE Referral SET Counter = Counter + 1 WHERE Ref_ID=" & InsertIntoID

  2. #2
    Join Date
    Dec 1969

    Default Did you DEBUG?

    Did you <BR>&nbsp; &nbsp; Response.Write SQL_query & "&#060;HR&#062;"<BR>to be sure you had a good value for Ref_ID?<BR><BR>And what, specifically, is the entire error?<BR><BR>I don&#039;t *think* that any of your names in that query are keywords, but you could always play it safe and do:<BR><BR>SQL_query = "UPDATE [Referral] SET [Counter]=[Counter] + 1 WHERE [Ref_ID_=" & InsertIntoID<BR><BR>Can&#039;t hurt; might help.<BR><BR><BR>

Posting Permissions

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