Stored Procedure - returning recordset and its recordCount 1

[rajkum]

Hi,
I have a stored procedure which returns a recordset.
I am using ASP to list the data from recordet and it works pretty fine. The part which bothers me is
1)..i cannot get the recordcount of the recordset.
2)..I am not being able to use value from the return parameter until I use the recordset.

Can I access the OUTPUT parameter(s) before the recordset?

Thanks,
RajKumar.

 

[nigelrivett]

The recordcount and output parameters are only accessible after the resultset is returned. If you work with client side disconnected recordsets then these will be available.
see

http://www.nigelrivett.net/DBAccess.inc.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.