|
Subject:
|
Nextrecordset
|
|
Posted By:
|
mikedeepak
|
Post Date:
|
12/21/2005 1:09:27 AM
|
Hi all,
Couild u please give me solution in the "ADO NextRecordset"Fox example
mystored proc is like this
Create Procedure prSample
AS
SELECT * FROM Table1
SELECT * FROM Table2
SELECT * FROM table3
Now i loop thru the recordset
While Not ObjRs is nothing
while Not ObjRs.eof
rseponse.write objrs(0)
objrs.movenext
wend
set objRs=ObjRs.nextRecordset
wend
"Now After looping thru all the Recordset i need to move to the first record of the first recordset"
Could anyone give the solution for this?????????
|
|
Reply By:
|
mtuppers
|
Reply Date:
|
4/28/2006 4:29:00 PM
|
Seems like you are making 3 sql statment. the solution I can think out is put them in to array. and using for next to show the record and ofcourse set the array back to 0.
|
