|
|
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?
>
|
