Re: [CDBI] Type binding

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.

- Perrin