Re: ANY subquery and PreparedStatements

  This is impossible because of the framework we use here... The SQLs
aren't stored  in java code, but in a separate XML file

On Wed, 2003-02-19 at 15:12, David Wall wrote:
> >   You're right... but it's actually based on user interaction (i.e.:
> > selecting items using checkboxes)
> >   I guess I'll just have to issue a query per item... ugly :-(
>
> Why can't you simply build the prepared statement on the fly based on the
> number of values to be placed in the IN list?  If you have 3 items, you just
> append three '?' and if you have 20 items, then you append 20 '?' to your
> list.  This way the number of '?' will match the number of
> PreparedStatement.setXXX() calls and you don't have to rely on the database
> handling all the nulls.  Since the list is fairly dynamic anyway, it's
> overall performance will be about the same (and it's much better than doing
> a series of queries instead).
>
> Of course, there are limits on how long a query can be for most databases,
> so you may find that if the list is too long, you'll run into query
> processor problems.
>
> David
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--

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