RE: Re: Difficulty inserting a large object using DBD::Pg

in reply to Re: Difficulty inserting a large object using DBD::Pg (kudra: do doesn't fix)
in thread Difficulty inserting a large object using DBD::Pg

Why don't you try this. Make sure the database table is the type you wish to use and then just use
$sth->bind_param(1,"$value")
this should place the value of $value into the database field as long as the database field is of a type to handle that input.

Comment on RE: Re: Difficulty inserting a large object using DBD::Pg

Replies are listed 'Best First'.
RE(3): Difficulty inserting a large object using DBD::Pg (kudra: binding without explicit types won't fix prob) by kudra (Vicar) on Jun 29, 2000 at 18:58 UTC
This does not work because it attempts to resolve the type itself, and defaults to varchar, as it did when I explicitly selected the type. It's another pg_atoi error.	[reply]

In Section Seekers of Perl Wisdom