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. =)
--
Sacha Chua <[EMAIL PROTECTED]> 3 BS CS geek =)
Ateneo Cervini-Eliazo Networks (ACENT) tel: 63(2) 426-6001 loc 5925
BOFH excuse #383: Your processor has taken a ride to Heaven's Gate on the UFO behind
Hale-Bopp's comet.
_
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]
