|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here! |
|
#1
April 17th, 2000, 02:33 AM
|
|||
|
|||
|
where clause: missing semicolon at end of SQL statement
<i><b>Originally posted by : Chris (csbelli@hotmail.com)</b></i><br />I am trying to do an insert statement with a where clause from ASP to Access 2000. This is my insert statement: strSQL = strSQl & "INSERT INTO Results2 (q1a,q1b,q1c,q1d) VALUES('" & q1a & "','" & q1b & "','" & q1c & "','" & q1d & "') WHERE ssn = 'ssn1' ; " I have tried every combination I can think of but I always get missing semicolon at end of SQL statement or Expected end of statement. Any help would be greatly appreciated. Thanks.<br />
|
|
#2
May 9th, 2000, 12:01 PM
|
|||
|
|||
|
<i><b>Originally posted by : Bob (bmacneal@dainrauscher.com)</b></i><br />I don't think you need a semi colon at the end of the query. Try it without. Other than that it looks ok.<br /><br /><br />------------<br />Chris at 4/17/2000 12:33:43 AM<br /><br />I am trying to do an insert statement with a where clause from ASP to Access 2000. This is my insert statement: strSQL = strSQl & "INSERT INTO Results2 (q1a,q1b,q1c,q1d) VALUES('" & q1a & "','" & q1b & "','" & q1c & "','" & q1d & "') WHERE ssn = 'ssn1' ; " I have tried every combination I can think of but I always get missing semicolon at end of SQL statement or Expected end of statement. Any help would be greatly appreciated. Thanks.<br />
|
|
| Viewing: ASP Free Forums > Database > SQL Development > where clause: missing semicolon at end of SQL statement |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
 |
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
