#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2001
    Posts
    29
    Rep Power
    0

    Question 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....

    Bob
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    No es importante
    Posts
    2,065
    Rep Power
    14
    You may be able to use the nextResultSet() method. Give this a try.
    El éxito consiste en una serie de pequeñas victorias día a día

    MySQL, MS SQL, MS ACCESS, Oracle Database Manager - http://victorpendleton.net/products/psdviewer.html

IMN logo majestic logo threadwatch logo seochat tools logo