Re: Escaping strings? - Mailing list pgsql-jdbc

From Thomas O'Dowd
Subject Re: Escaping strings?
Date
Msg-id 1036376040.13828.21.camel@beast.uwillsee.com
Whole thread Raw
In response to Escaping strings?  (Timothy Reaves <treaves@silverfields.com>)
Responses Re: Escaping strings?  (Timothy Reaves <treaves@silverfields.com>)
List pgsql-jdbc
Use the setString() method of PreparedStatement and it will escape
things for you.

Tom.

On Mon, 2002-11-04 at 11:06, Timothy Reaves wrote:
>     What is the proper way to insure a text string (i.e. one read from a
> JTextField.getText()) is propery escaped?  I assumed the JDBC driver would
> do this automatically, but it does not.  An ' character will cause the
> JDBC driver to throw an exception.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
--
Thomas O'Dowd, CEO, Nooper.com - Mobile Services Inc., Tokyo, Japan
i-mode & FOMA consulting, development, testing: http://nooper.co.jp/


pgsql-jdbc by date:

Previous
From: Timothy Reaves
Date:
Subject: Escaping strings?
Next
From: Timothy Reaves
Date:
Subject: Re: Escaping strings?