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: simple question, rowcount
Date: Sep 16 1997 7:54PM

Jamie Thingelstad wrote:
> 
> I feel almost silly asking this but I can't find the solution
> offhand... I am executing the following:
> 
>    $dbh->dbcmd($sql);
>    $dbh->dbsqlexec;
>    $dbh->dbresults;
>    ($fields...) = $dbh->dbnextrow;
>    $dbh->dbcancel;
> 
> What can I call after $dbh->dbresults to see if the select returned
> any rows? The select I'm calling will return either 0 or 1 rows.

DBROWS(), as in

if($dbh->DBROWS) {
	($fields...) = $dbh->dbnextrow;
}

Michael
-- 
Michael Peppler       -||-  Data Migrations Inc.
mpeppler@datamig.com  -||-  http://www.mbay.net/~mpeppler