April 21, 2006 at 7:40 pm
There is a stored procedure which contains only 4 select statements. and the front end asp page need to display the four result sets. Is that possible?
My previous experience was to return only 1 record set or return 1 temp table to hold all 4 result set, but I never see that a proc returns multiple record sets. can somebody give me a example of usage of this type of proc?
April 22, 2006 at 8:16 am
It has been a while since I did old fashioned ASP but there was a NextRecordSet method on a RecordSet object.
FirstRs.Open "YourProc"
Set SecondRs = FirstRs.NextRecordset
April 22, 2006 at 6:02 pm
Thanks for the reply. I didn't know there is such kind of function. I will do some more research see if asp.net has this function too.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply