General discussion

Locked

Missing semicolon at end of SQL statement.

By arobin4 ·
Good morning,
Any suggestions? I keep getting the following error when I try to INSERT data into my databse from my asp webpage. Here is the code that produces the error:

MM_editQuery = "insert into Clarify_Case_Number (engineer_id) values (10),(20),(30);"

If (Not MM_abortEdit) Then
' execute the insert
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute ' ** Code fails here **
MM_editCmd.ActiveConnection.Close


I am trying to insert 10, 20, and 30 into the engineer_id column when the code executes.

Thanks!
Aaron
arobin4@hotmail.com

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Networks Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums