I have a stored procedure that returns multiple recordsets for example:
select employeeId from employee
select termID from term
The number of records can vary depending on which stored procedure is called (sp name is passed as a parameter into the ASP page).
In my ASP page I would like to know how many recordsets are present. Is there any way to do this? Basically if there is more than one I want to redirect to another page. I know I can page through the recordsets with:
Set rst = rst.nextRecordset
However, this gives an error if there isn't another recordset. I can't seem to trap that error either but maybe someone has a method for doing that.
Any way that I can determine if there is more than one recordset returned would be fine.
Thanks.
select employeeId from employee
select termID from term
The number of records can vary depending on which stored procedure is called (sp name is passed as a parameter into the ASP page).
In my ASP page I would like to know how many recordsets are present. Is there any way to do this? Basically if there is more than one I want to redirect to another page. I know I can page through the recordsets with:
Set rst = rst.nextRecordset
However, this gives an error if there isn't another recordset. I can't seem to trap that error either but maybe someone has a method for doing that.
Any way that I can determine if there is more than one recordset returned would be fine.
Thanks.