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 PROTECTED]
