Return output parameter then a recordset from an sp

[saroyal]

I am returning a recordset from a stored procedure which takes one input parameter and one output parameter. The problem is that I haven't figured out how to get the output parameter first and then the recordset.

I set the command connection details, command text, etc. and append the two parameters, then I return the recordset using:

SET rdsList = com.Execute

Then I can loop through the recordset, and at the end I use:

SET rdsList = rdsList.NextRecordset

which seems to populate the output parmeter, but I then can no longer access the recordset. Is there a way to get the output parameter first and then recordset?

Simon