sybperl-l Archive

From: Michael Peppler <mpeppler at MBAY dot NET>
Subject: SP_HELP
Date: Dec 14 1998 9:32PM

>>>>> "Eric" == Eric Johanson  writes:

Eric> Hello, When I run a SQL statement "sp_help users"

Eric> The $dbh->dbnextrow(0); command only returns a limited amount of
Eric> information.  "address, dbo, user table "

Eric> How to I return all the row names, and datatypes?

You must call dbresults() in a loop, until it returns NO_MORE_RESULTS:

while($dbh->dbresults != NO_MORE_RESULTS) {
    while(@dat = $dbh->dbnextrow) {
	print "@dat\n";
    }
}

Michael
-- 
Michael Peppler         -||-  Data Migrations Inc.
mpeppler@mbay.net       -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com
Sybase on Linux mailing list: ase-linux-list@isug.com