General discussion


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 **

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


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums