How to detect an object

[Dooza]

Hi there,I am using a stored procedure that outputs multiple recordsets.
I use <% SET rsDisplay = rsDisplay.NextRecordset() %> to step to the
next recordset.

In one particular condition the final recordset is not passed to the
page, so I need to detect that the object is empty.

I did just try <% If NOT rsDisplay.EOF Then %> but I get:

Microsoft VBScript runtime error '800a01a8'

Object required

Any ideas how I can trap this error? I just want the area on the ASP
page not to display when there isn't a final recordset.

Cheers,

Steve

 

[Dooza]

Hi there,I am using a stored procedure that outputs multiple recordsets.
I use <% SET rsDisplay = rsDisplay.NextRecordset() %> to step to the
next recordset.

In one particular condition the final recordset is not passed to the
page, so I need to detect that the object is empty.

I did just try <% If NOT rsDisplay.EOF Then %> but I get:

Microsoft VBScript runtime error '800a01a8'

Object required

Any ideas how I can trap this error? I just want the area on the ASP
page not to display when there isn't a final recordset.

Cheers,

Steve

Ah ha, found it <% If not (rsDisplay is Nothing) Then %>

Steve