From: | Webb Sprague <wsprague100(at)yahoo(dot)com> |
---|---|
To: | Charles Curley <ccurley(at)trib(dot)com>, pgsql-novice(at)postgreSQL(dot)org |
Subject: | Re: Pg.pm oddity with apostrophes |
Date: | 2000-08-26 17:33:19 |
Message-ID: | 20000826173319.4441.qmail@web805.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I haven't messed to much with it, but I think that if
you use two apostrophes like '', that may work to
escape it.
--- Charles Curley <ccurley(at)trib(dot)com> wrote:
> I am using pg.pm with perl to interface between a
> web server,
> Apache, and postgres. Pg.pm is as follows:
>
>
#-------------------------------------------------------
> #
> # $Id: Pg.pm,v 1.8 1998/09/27 19:12:22 mergl Exp $
> #
> # Copyright (c) 1997, 1998 Edmund Mergl
> #
>
#-------------------------------------------------------
>
>
> [PostgreSQL 6.5.1 on i686-pc-linux-gnu, compiled by
> gcc pgcc-2.91.66]
>
>
> 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. If I remove the apostrophe,
> the otherwise identical
> record goes in just fine. I am escaping the
> apostrophe correctly, as far
> as I know. The insert query is as follows:
>
> Insert into contacts VALUES ( 'Mr.', 'Patrick',
> 'O\'Neil', blah, blah... 'http://URL' ); "
>
> I can insert the name from psql with no problems,
> which makes me think it
> is a Pg.pm problem.
>
> --
>
> -- 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
> ATTACHMENT part 2 application/pgp-signature
__________________________________________________
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Jesus Aneiros | 2000-08-26 17:40:21 | Re: Pg.pm oddity with apostrophes |
Previous Message | Charles Curley | 2000-08-26 16:42:11 | Pg.pm oddity with apostrophes |