Thread: Run 2 Query in Single Connection
10-01-04, 03:17 #1Registered User
- Join Date
- Oct 2004
- Kuala Lumpur
Unanswered: Run 2 Query in Single Connection
need your expertise on this problem.
I tried to run 2 queries in single connection. But it doesnt work to the second query
page will return an error but execute the frist query only. How can i solve this problem.
I'm using Microsoft Access 2000. Here are the code an error that return
Dim objConn, strSQL1, strSQL2
Set objConn = Server.CreateObject("ADODB.Connection")
strSQL1 = "Update ADM_USERTAB Set USER_PWD = '" & new_pwd & "' where USER_ID = '" & userid & "'"
set rsUpdate_Pwd = objConn.Execute(strSQL1)
strSQL2 = "Update EGBIT_PWD_STATUS Set password_status = 'change' Where user_id = '" & userid & "'"
set rsstatus = objConn.Execute(strSQL2)
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
( it refering to line that execute set rsstatus = objConn.Execute(strSQL2) )
Please help me on this. Thanks in advance
10-04-04, 03:25 #2Useless...
- Join Date
- Jul 2003
UPDATE queries do not return recordsets.That which does not kill me postpones the inevitable.