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.

Sorry, You're right it was perl 5 on the old machine, I inherited this and the server went down over the weekend. I've been transfering all the old scripts onto the new machine and this is the last issue I am having. Thanks for the info I will look into these suggestions.

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.