Re: Pg.pm oddity with apostrophes

On Sat, Aug 26, 2000 at 08:33:53PM -0400, Anthony E . Greene wrote:
> On 26 Aug 2000 12:42 Charles Curley wrote:
> >The oddity I have hit is that if I try to inset a name with an apostrophe
> >in it (e.g. O'Neil), pgsql belly-aches and returns an error of 7. The
> >record is not inserted.
>
> Perl will escape the apostrophe and will not pass the backslash on to the
> backend. You will need to use a double backslash:
>
> $sql = "INSERT INTO contacts VALUES ('Mr.','Patrick','O\\'Neil','http://URL')";

Thanks. That also did not work.

--

-- C^2

No windows were crashed in the making of this email.

Looking for fine software and/or web pages?
http://w3.trib.com/~ccurley