sybperl-l Archive

From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: General question
Date: Jul 2 1999 3:27PM

Saxena, Arun writes:
 > 
 > I am doing the folowing, but does not seem to work..
 > 
 > $sql = "select ....";
 > $sql2 = "select...";
 > 
 > $syb_login->dbsqlcmd($sql);
 > $syb_login->dbsqlcmd($sql2);
 > $syb_login->dbsqlexec;
 > $syb_login->dbresults;
 > 
 > Am I doing somethinh wrong ?

well, you need to call dbresults() in a loop, because you're executing 
two SELECT statements.

you should use something like:

while($syb_login->dbresults() != NO_MORE_RESULTS) {
    while(@data = $syb_login->dbnextrow) {
	... # do something with the @data from the select
    }
}

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