From: PETER PAULY <ppauly@usa.net>
To: pgsql-sql@postgresql.org
Subject: Odd characters in inserted data...
Date: 29 Nov 98 15:29:47 MST
Message-ID: <19981129222947.29657.qmail@www0n.netaddress.usa.net> (raw)
I'm using the "C" interface to write CGI code for a web application. I allow
the user to type data into a particular field, and am storing that data into a
field in a postgres database.
The problem is, I have to filter the data that the user entered to remove any
single quotes and other odd characters so that my SQL command doesn't get
messed up. I'm building the command with printf and passing the filtered
data from the user as so:
update tablename set comment = '%s' where .....
And %s is substituted in the printf with the user data. If the user typed in a
single quote, it would cause havoc with the sql statement. My question is, is
there a better way to pass data to these commands, than to build a command
string like you see above? My preference would be to pass a pointer to the
data, or something like that. (same issue with insert).
____________________________________________________________________
Get free e-mail and a permanent address at http://www.netaddress.com/?N=1
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: ppauly@usa.net
Subject: Re: Odd characters in inserted data...
In-Reply-To: <19981129222947.29657.qmail@www0n.netaddress.usa.net>
References: <19981129222947.29657.qmail@www0n.netaddress.usa.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox