PleaseGiveHelp
Programmer
I am doing something wrong with my query string because I continuously get a message similar to:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ','.
/User_Info/processChanges.asp, line 15
When I hit the submit button. This is the code:
strSQL = "execute test_script" & user_id & ", '" & password & "', '" & user_id_1 & "', '" & user_id_2 & "', " & deleted & " "
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.Open strSQL,db,0,1
What is wrong with the comma (in the error)? I can't see the problem. Please help.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ','.
/User_Info/processChanges.asp, line 15
When I hit the submit button. This is the code:
strSQL = "execute test_script" & user_id & ", '" & password & "', '" & user_id_1 & "', '" & user_id_2 & "', " & deleted & " "
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.Open strSQL,db,0,1
What is wrong with the comma (in the error)? I can't see the problem. Please help.