in reply to Re: SQL statement produces no results when executed using DBI's prepared statement, but one record when executed directly in MySQL. WHY?
in thread SQL statement produces no results when executed using DBI's prepared statement, but one record when executed directly in MySQL. WHY?

Thanks

My error was to use fetchrow_array instead of fetchrow_arrayref (which is what, in fact, I'd intended). Making that change fixed all.

Just goes to show that trying to code when you're over-tired is not conducive to being productive, allowing silly errors to creep in. Nor is it conducive to remaining sane. :-(

Thanks

Ted

  • Comment on Re^2: SQL statement produces no results when executed using DBI's prepared statement, but one record when executed directly in MySQL. WHY?

In Section Seekers of Perl Wisdom