[CDBI] Type binding
perrin at elem.com
Wed Jun 7 19:54:10 BST 2006
On Tue, 2006-06-06 at 22:19 -0700, Bill Moseley wrote:
> I received this error on Postgresql 8.1.3:
> : DBD::Pg::st execute failed: ERROR: invalid input syntax for type boolean: "34696"
> [for Statement "SELECT me.id, me.cart, me.registration, me.transaction_by, me.transaction_time, me.amount, me.transaction_id, me.transaction_type, me.invoice, me.comment
> FROM cart_transaction me
> WHERE ( me.cart = ? ) ORDER BY transaction_time
> " with ParamValues: 1='34696'] at /home/moseley/local/share/perl/5.8.4/DBIx/ContextualFetch.pm line 52.
> at /home/moseley/local/share/perl/5.8.4/Class/DBI/Relationship/HasMany.pm line 144
> The query works fine in psql.
Try it in vanilla DBI. It doesn't look like a Class::DBI thing, but
it's hard to be sure. DBI is usually good about guessing data types.
More information about the ClassDBI