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: Monty Scroggins <Monty dot Scroggins at wcom dot com>
Subject: Re: How to the no of rows
Date: Apr 29 2000 3:48PM

I had trouble with the sybase call to get the returned rowcount, so
I just incremented a counter as the data rolled in:

my $dbrowcount=0;
#for each row returned from the query..
while (@dbdata=$dbh->dbnextrow) {
    #for some reason the sybase call for row count wouldn't work - I'll
count em myself
    $dbrowcount++;
....

This could be fixed now...  but at the time I was writing this application I
could not get the proper results without counting the rows myself...

Monty

----- Original Message -----
From: "venkat Reddy" 
To: "SybPerl Discussion List" 
Sent: Saturday, April 29, 2000 9:27 AM
Subject: How to the no of rows


>   hi,
>
>  How do I know the number of rows in any table? After the select query
executed.How can I find out the query returned 0 rows or x rows?
>