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]
