problem in preparedstatements

From: Felipe Schnack <felipes(at)ritterdosreis(dot)br>
To: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: problem in preparedstatements
Date: 2003-02-18 17:59:37
Message-ID: 1045591177.1576.101.camel@desenv1.ritterdosreis.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Let's say I have a query that will use the ANY subquery... How i pass
multiple expressions to it? I mean, let's take this example:
"select * from tablename where id any (?)"
Then, I prepare this query. How can I set that parameter to build a
query like
"select * from tablename where id any (1,2,3)"
???
--

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

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

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jon Swinth 2003-02-18 18:37:32 Re: PrimaryKeyExists Error
Previous Message Barry Lind 2003-02-18 16:44:04 Re: DataSource suddenly drops all connections?