[CDBI] Class::DBI giving error where none before.

John Day johnday at wordsnimages.com
Tue Aug 29 14:55:55 BST 2006


The problem was a field name - I was working on this for far too long 
into the early morning hours.


At 08:56 AM 8/29/2006, John Day wrote:
>Late yesterday I found that I am getting this error from code which 
>previously functioned, note their appears to be an additional single 
>quote after the key value. Any clues? Class::DBI eas 3.0.14 but the 
>same happens on 3.0.15 when I updated today.
>Error executing run mode 'mode500': 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 'order,
>user, t5, coupon
>FROM   searchterm
>WHERE  id='674'' at line 1 [for Statement "SELECT t3,
>rejection, template, t4, thankyou, searchterm, t1, t2, order, user, t5,
>FROM   searchterm
>WHERE  id=?
>" with ParamValues: 0='674'] at
>/usr/lib/perl5/site_perl/5.8.7/DBIx/ContextualFetch.pm line 52.
>  at admt.pl line 8
>ClassDBI mailing list
>ClassDBI at lists.digitalcraftsmen.net

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digitalcraftsmen.net/pipermail/classdbi/attachments/20060829/d925d50e/attachment.htm

More information about the ClassDBI mailing list