SemiColn error?

Results 1 to 2 of 2

Thread: SemiColn error?

  1. #1
    GripThor Guest

    Default SemiColn error?

    everything worked find untill I put the where command into my sql statment now I get a semicoln error and since I havn&#039;t ever put a semicolin into my statment befour I don&#039;t know what its asking for <BR><BR>user_update = "INSERT INTO Table1 (info) values (&#039;" & message & "&#039;) where id=" & userid<BR> <BR>set rc=con.execute(user_update)<BR><BR>??<BR>

  2. #2
    Nils Bilhorn Guest

    Default RE: SemiColn error?

    Since when was it possible to have where conditions for insert statements in SQL?<BR><BR>If you want to change a row, the syntax is<BR><BR> user_update = "update table1 set info = &#039;" & message & _<BR> "&#039; where id = " & userid

Posting Permissions

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