PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at MBAY dot NET>
Subject: Re: how to do this in perl
Date: Jun 18 1998 8:33PM

Travis Lee writes:
 > hi Michael,
 > 
 > thanks for your help. and the code works.
 > but i'm having trouble by using the 'standard' db-library api
 > to get it works.
 > 
 > $syb->dbcmd($query);
 > $syb->dbsqlexec();
 > $syb->dbresults();
 > $code = $syb->dbnextrow();
 > print "code: $code\n";
 > 
 > i'm unable to get the $code from the query. 

You must loop on dbresults(), until it returns NO_MORE_RESULTS, and in 
that loop you call dbnextrow() to see if there are any rows to
retrieve.

Please see the Sybase docs on programing with DBlibrary at
http://sybooks.sybase.com. 

Michael
-- 
Michael Peppler         -||-  Data Migrations Inc.
mpeppler@datamig.com    -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com