On Friday 24 August 2001 11:15, you wrote:
> On Thu, Aug 23, 2001 at 07:46:48PM +0800, sherwin wrote:
> > I came across with the error when I entered
> > "EM's Qtr" (without the leading/trailing quotes) in
> > Warning: PostgreSQL query failed: ERROR: parser: parse error at or near
> > "s" in /home/eric.rosel/public_html/linux10/include/pg_db.inc on line 222
>
> Classic SQL problem. =) Eric, you've probably already fixed this to double
> the apostrophes, and also fix the HTML on output?
>
> Okay, just in case anyone else runs into this:
>
> SQL strings are delimited by single quotes, like this: 'Hello world!' That
> makes it break when you have a single apostrophe inside the string: 'This
> can't be.' So you need to double the apostrophes. 'This''ll work.'
>
> Search and replace. =)
an alternative would be to "escape" them with a backslash character so that
"this\'ll work too"
thanks sacha!
-eric
--
�.--. �Enrique D. Rosel II � � � � � � � � � � office://+63.2.894.3592/
( () ) Q Linux Solutions, Inc.
�`--\\ A Philippine Open Source Solutions Co. �http://www.q-linux.com/
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
To subscribe to the Linux Newbies' List: send "subscribe" in the body to
[EMAIL PROTECTED]
