Re: bytea escaping?

2003-10-09 Thread Ragnar Hojland Espinosa
On Wed, Oct 08, 2003 at 09:48:56AM -0700, David Wheeler wrote: 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,

Re: bytea escaping?

2003-10-09 Thread Tim Bunce
On Wed, Oct 08, 2003 at 09:48:56AM -0700, David Wheeler wrote: 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,

Re: bytea escaping?

2003-10-09 Thread David Wheeler
On Thursday, October 9, 2003, at 04:25 AM, Tim Bunce wrote: That's because you're binding it twice. You need to bind each argument with bind_param(), and then call execute() without any arguments. That shouldn't be needed according to the DBI spec. The type set by a previous bind_param() is

bytea escaping?

2003-10-08 Thread Ragnar Hojland Espinosa
I got a column of type bytea, and found out that DBD::Pg is complaining when it sees backslashes. I'm using prepare/execute and was under the impression that values added that way were automatically escaped/quoted by DBI, but i have to s/\\//g; to escape the backslashes (do i need to escape

Re: bytea escaping?

2003-10-08 Thread David Wheeler
On Wednesday, October 8, 2003, at 07:27 AM, Ragnar Hojland Espinosa wrote: I got a column of type bytea, and found out that DBD::Pg is complaining when it sees backslashes. I'm using prepare/execute and was under the impression that values added that way were automatically escaped/quoted by