asp_databases thread: RES: Error:Operation is not allowed when the object is closed
what kind of object [rs] variables is openning??
rs is null..
De: Catherine Michel [mailto:cmichel101@h...]
Enviada em: terça-feira, 4 de junho de 2002 15:44
Para: ASP Databases
Assunto: [asp_databases] Error:Operation is not allowed when the object
I have a command object and the command type is a stored procedure. The
stored procedure is a select statement. I want to view 5 result per page
This is some of my code:
Set cmdResult = Server.CreateObject("ADODB.Command")
cmdResult.CommandType = adCmdStoredProc
cmdResult.CommandText = "sp_Practitioner13"
cmdResult.ActiveConnection = cnToronto
Set rs = Server.CreateObject("ADODB.Recordset")
rs.CursorLocation = 3
rs.CursorType = 3
rs.Open = cmdResult
if rs.EOF then <- The error occurs at this line
I have this error message:
Operation is not allowed when the object is closed.
Any help would be very appreciated!