Re: [OT] creating preparedStatement for where in clause

[CRPence <CRPbottle@xxxxxxxxx>]

Ashish Kulkarni wrote:
> I have an SQL query like below
>
> select * from table1 where test in ('','123', '345');
>
>
> How do I create preparedStatement for this, the issue is the
> number of values in <ed> IN predicate can be different;
> for example, the query can be as below depending on what user
> selects on screen
>
> select * from table1 where test in ('','123', '345');
>
> or
>
> select * from table1 where test in ('','123', '345', '1233');
>
> or
>
> select * from table1 where test in ('','123');

  FWiW the question seems general for SQL rather than specific to 
any language support of the SQL; i.e. not specific to JAVA. 
Presumably that is why the subject is noted as OT.  Rather than 
posting an Off Topic discussion to a group, why not just post the 
technical question to the Midrange-L which is not specific to a 
language or utility\application?  Regardless, ...

  If there is a limit to the number of values selected on the 
screen, e.g. five values, then the following should be possible:

    WHERE test IN (?, ?, ?, ?, ?)

  Any parameter markers that are not given a value from the screen 
can be set to the same value as the first [possibly the only] value 
from the screen.  As such, the first example would translate into:

    WHERE test IN ('', '123', '345', '', '');

Regards, Chuck