MySQL Forums
Forum List  »  Perl

Re: DBD-mysqlPP and MySQL v4.1
Posted by: A. Sylvester
Date: September 23, 2006 10:42AM

Thanks for responding Bill Karwin. Yes I did try running the exact same SELECT statement (SELECT * FROM MEMBERS) from the mysql comand-line interface and it works. I do not have any code that checks for errors after I prepare the query yet. What I have noticed also is that after running the PREPARE and EXECUTE statements, "$sth->rows" has the value of 0 which is not correct.


Bill Karwin Wrote:
-------------------------------------------------------
> Source code for mysqlPP.pm is here:
> http://search.cpan.org/src/OYAMA/DBD-mysqlPP-0.04/
> mysqlPP.pm
>
> It appears that the line you're mentioning is
> trying to use an iterator for records, but
> failing. The iterator itself is probably undef.
> Perhaps the SELECT statement failed? Are you
> checking for errors after you prepare the query?
>
> Another good test is to try the exact same SELECT
> query in the mysql command-line interface. That
> is, remove Perl from the test. Does the query
> work, or does it give an error?

Options: ReplyQuote


Subject
Written By
Posted
September 22, 2006 11:43AM
September 22, 2006 11:16PM
Re: DBD-mysqlPP and MySQL v4.1
September 23, 2006 10:42AM
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.