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
