Greetings -
I have a simple CGI script written in Perl (using v5.8) that seemed
to work well under MySQL 3.23.49. However, after recently upgrading to
version 3.23.55 I am running into the following problem. Previously, I used
the rows() function to return the number of rows returned from a SELECT
query as in the example below. However, this has now ceased to function as
before, and returns zero (0) in the $count variable no matter what is
returned from the database. Can anyone tell what might have changed, or
what I might do to get around this problem?
#Set the database query
my $query = "SELECT * FROM table_name";
#Run a query to return all records
my $sth = $dbh->prepare($query);
$sth->execute;
#Count the number of records returned
my $count=$sth->rows();
Many thanks for any help you can provide...
Colin
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
