February 5th, 2003, 08:31 AM
Simple (?) db query question
This is slanted more towards MSSQL because I'm using stored procedures but I'm hoping someone can answer just the same.
I've noticed that I can build and run a sp that contains 2 or more independent queries. When I run them, I get 2 or more lines of ouput (in the Query analyzer or whatever). Since you set the pointer to 0,0 to get the first field of the first line of output, what do you, if anything, do to get to that second discreet line of output?
Just curious - I've seen examples in books and such and wondered how to get that second line back out to a web page.
Thanks in advance....
February 5th, 2003, 10:42 AM
You may be able to use the nextResultSet() method. Give this a try.