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

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


Fixed.

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

John


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,
>coupon
>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
>
>http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi
>

-------------- 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