Hello The following code
SQL = "Execute usp_FetchServiceTerminations @a_szAuthcode='" & AuthCode & "',@a_StartDate='" & GetTwoDigitDate(StartDate) & "',@a_EndDate='" & GetTwoDigitDate(EndDate) & "'" SET GCRS = ConnCDI.Execute(SQL) Response.write "<table border=""1"">" & vbCRLF Response.write "<tr>" & vbCRLF Response.write "<td class=""tblHeader"" colspan=""5"">Cancellations for " & StartDate & " - " & EndDate & "</td>" Response.write "<tr>" & vbCRLF IF GCRS.EOF or GCRS.BOF THEN the line above generates Cancellations for 11/01/2002 - 11/30/2002 ADODB.Recordset error '800a0e78' Operation is not allowed when the object is closed. /includes/ReportFunctions.inc, line 30 Any ideas. Obviously I do not close the recordset or set it equal to nothing, so I do not understand the error. Steve Abaffy IT Director CDI Telecom 972-503-6600 ext 2223 --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
