in reply to DBD::mysql::st execute failed

I may be going out on a limb here, but I think jmccall meant mysql4, not perl4. That would explain the 'upgraded server' comment.

Before you do anything, you need to add the following after line 63: 

print "query is $lpszQuery\n";

[download]
And verify that the SQL is still valid for the version of mysql that you are currently using

  • Comment on Re: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at /www/cgi-bin/recordsets/BaseRecordset.pm line 66.
  • Download Code

In Section Seekers of Perl Wisdom