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: justin at wwwebdesign dot com
Subject: Re: simple question, rowcount
Date: Sep 16 1996 9:23PM


   Here ya go, this may help:

  $dbh->dbcmd($sql);
  $dbh->dbsqlexec;
  $dbh->dbresults;
  while (%field = $dbh->dbnextrow(1)) {
      push ( @stuff ,  $field{prod_id} )
  }


  have phun!


-_-_-_-_-_-_-_-_-_-_-_-




>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.
>
>--
>Jamie Thingelstad, CTO          (Fax) 612.338.0069 (Voice) 612.338.0049x24
>Concerto Technologies   123 North 3rd St. Suite 300, Minneapolis, MN 55401