How can I use the last recordset in a SP that return 3 recordsets ?

Hello,

I have a SP1 that is calling another SP2,
SP2 is using select and returning records

So in SP1 I get 3 different record sets
(as I can see it on Query Analyzer - one after the other)

When I'm trying using the ASP page I get this error:
"Item cannot be found in the collection corresponding to the requested name or ordinal."

How can I access the last recordset ?If you really mean ASP.NET, the DataReader has a NextResult method that can get you from result set 1 to 2, and then to three.|||Thanks, but actually I need to do it on ASP,

what is the eqvivalent for ASP ?

H - E - L - P|||ADO has a NextRecordset method:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthnextrec.asp

This is really an ASP.NET forum, so other places may be better for info on ADO classic...