escaping the '

From: Andy Lewis <alewis(at)mpsi(dot)net>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: escaping the '
Date: 1998-05-22 14:00:35
Message-ID: Pine.LNX.3.95.980522085023.14868A-100000@shell.mpsi.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I am running Postgres 6.3.2 / PHP 3.0 on Linux 2.0.30.

I have a table that has 16 text fields in it. I have a PHP form that allows a
user to enter info into that field. When a user enters an ' as in " item's " the
query will fail. I have played around with it and can execute the query without
error if I escape the ' . Such as " item\'s "

Here's the big question:

Is there anyway other than doing a ereg_replace(); in PHP to get around this
problem? If I do a ereg_replace("'", "\'", $f1) in the PHP file and execute it,
I have no problem. I dont recall having this problem in the earlier version of
Postgres.

As always, thanks in advance!

Andy

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Eric McKeown 1998-05-22 22:41:10 Re: [SQL] escaping the '
Previous Message Tom Good 1998-05-22 12:35:17 Re: [SQL] Are there JDBC that used with PostgreSQL?