
October 23rd, 2002, 02:44 PM
|
Contributing User
|
|
Join Date: Apr 2002
Location: The Great White North
Posts: 361
Time spent in forums: 58 m 50 sec
Reputation Power: 17
|
|
SQL Error - Command text was not set for the command object
I've added the following code to a registration page, to allow a user's registration to be cancelled.
Code:
If "" & request("Cancel") <> "" then
paramlist = iUID & "," & iEID
set oRSCancelEventUser = CreateObject("ADODB.RecordSet")
set oRSCancelEventUser= DB.GetRS(sql.GetStr
(CancelUserEventEntry,paramlist),sMsg)
if sMsg = "" then
set oRSCancelEventUser = nothing
response.redirect "EventRegistrations.asp"
else
response.write sMsg
end if
set oRSCancelEventUser = nothing
end if
The error I receive is "GetRS : Command text was not set for the command object."
Any ideas as to the problem or suggestions as to how to debug? Thanks in advance.
Last edited by aspnewbie : November 12th, 2002 at 09:54 AM.
|