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

    Join Date
    Sep 2001
    Rep Power

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

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

    Join Date
    Jan 2003
    No es importante
    Rep Power
    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