Postgres Pro
Downloads
Home   >   mailing lists

ANY subquery and PreparedStatements - Mailing list pgsql-jdbc

From Felipe Schnack
Subject ANY subquery and PreparedStatements
Date
Msg-id 1045657464.24753.13.camel@desenv1.ritterdosreis.br
Whole thread Raw
Responses Re: ANY subquery and PreparedStatements  (Pavel Fokin <pavel@openvillage.info>)
Re: ANY subquery and PreparedStatements  (Csaba Nagy <nagy@ecircle-ag.com>)
List pgsql-jdbc
Tree view 
  I'm afraid it kind of impossible to use PreparedStatements with the
"ANY" subquery keyword... For example, if I take this query and prepare
it:
  "select * from <table> where <field> any (?)"
  How can I set my parameter as a list of values, so my query searches
for for different values of the specified field?

--

Felipe Schnack
Analista de Sistemas
felipes@ritterdosreis.br
Cel.: (51)91287530
Linux Counter #281893

Centro Universitário Ritter dos Reis
http://www.ritterdosreis.br
ritter@ritterdosreis.br
Fone/Fax.: (51)32303341

pgsql-jdbc by date:

Previous
From: Roj Niyogi
Date:
Subject: JSP AccessControlException error
Next
From: Pavel Fokin
Date:
Subject: Re: ANY subquery and PreparedStatements