MySQL Forums
Forum List  »  Perl

Re: DBD-mysqlPP and MySQL v4.1
Posted by: Bill Karwin
Date: September 23, 2006 12:44PM

> I do not have any code that checks
> for errors after I prepare the query yet.

That would seem to be the best next step.

> after running the
> PREPARE and EXECUTE statements, "$sth->rows" has
> the value of 0 which is not correct.

The $sth->rows method returns rows affected by the last INSERT/UPDATE/DELETE.
It isn't the count of rows returned by a SELECT.
See http://search.cpan.org/~timb/DBI-1.52/DBI.pm#rows

Regards,
Bill K.

Options: ReplyQuote


Subject
Written By
Posted
September 22, 2006 11:43AM
September 22, 2006 11:16PM
September 23, 2006 10:42AM
Re: DBD-mysqlPP and MySQL v4.1
September 23, 2006 12:44PM
September 24, 2006 09:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.