Also, when executing a query from the connection object as below - if the query is not a row-returning query or even if the result set is empty - IT IS NOT RETURNED...
This is one of the reasons I typically stick to creating a new recordset object and opening it, instead of assigning one to a (potential) result of a .Execute method call. If you don't want to do that, you have to check whether you indeed have a recordset, and what its status is. HTH, Tore. -----Original Message----- From: David L. Penton [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 12:32 PM To: ActiveServerPages Subject: RE: Strange Error ADO What is in SQL? Is it a stored procedure that needs SET NOCOUNT ON perhaps? David L. Penton, Microsoft MVP JCPenney Application Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript SQL BOL: http://www.davidpenton.com/sqlbol -----Original Message----- From: Steve Abaffy [mailto:[EMAIL PROTECTED]] Hello I have the following code Line 57 - SetConnection Line 58 - Set CDR = ConnCDI.Execute(SQL) Line 59 - IF CDR.EOF then Line 60 - code here Line 61 - ELSE Line 62 - More code here Line 63 - END IF The following error comes up Error Type: ADODB.Recordset (0x800A0E78) Operation is not allowed when the object is closed. /Internal_OLD/CDR.asp, line 59 I have put a respone.end after line 58 and line 58 executes fine so how could the Object be closed one line later??? Any insight????? --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
