sybperl-l Archive

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