On Wednesday, October 8, 2003, at 08:55 AM, Ragnar Hojland Espinosa wrote:


Hi David, hm.... i thought i had mentioned it too.. but that doesnt work either:

my $sth = $dbh->prepare ("INSERT INTO emails (id, fromhdr, subjecthdr,
datehdr, wholemessage, plaintext) VALUES (?, ?, ?, ?, ?, ?);") || die "$|";


$sth->bind_param (5, $wholemessage, { pg_type => DBD::Pg::PG_BYTEA });

$sth->execute ($id, $from, $subject, $date, $wholemessage,
$plain_text->string) || die "$|";

That's because you're binding it twice. You need to bind each argument with bind_param(), and then call execute() without any arguments.


HTH,

David

--
David Wheeler                                     AIM: dwTheory
[EMAIL PROTECTED]                              ICQ: 15726394
http://www.kineticode.com/                     Yahoo!: dew7e
                                               Jabber: [EMAIL PROTECTED]
Kineticode. Setting knowledge in motion.[sm]



Reply via email to