Re: [GENERAL] Parser error

From: Charles Hornberger <charlie(at)pressflex(dot)com>
To: Djon Kleine <maildjon(at)nl01(dot)worldstats(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Parser error
Date: 1999-06-07 23:29:45
Message-ID: 3.0.5.32.19990607162945.00b303a0@k4azl.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

You're probably not escaping single quotes. If someone enters "it's" and
you don't transform it to "it\'s", the parser will fail. I don't know if
there's a builtin function for this in Perl -- in PHP you can call
addslashes() like so:

$foo = addslashes($foo);

Cheers,
Charlie

At 08:55 PM 6/7/99 +0200, you wrote:
>Hi,
>I have a problem with postgresql and perl.
>I made an database and it is all working fine at my place but by "some"
>other persons not. But this is diffrend from computer to computer.
>At some places it's working fine and onother it is not working at all.
>Really weird if you ask me..
>
>The error is :
>ERROR: parser: parse error at or near "s"
>
>The script logs in with a username and password.
>
>Cya,
>Djon Kleine
>
>
>

Browse pgsql-general by date

  From Date Subject
Next Message selkovjr 1999-06-07 23:33:38 Re: [GENERAL] Geometric, getting x and y co-ordinates GOING MAD!!!!!
Previous Message Jackson, DeJuan 1999-06-07 22:40:03 RE: [GENERAL] 8 K Limit??