Re: ANY subquery and PreparedStatements

Felipe Schnack wrote:

> 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?
>
>
>
Hello,

You can use a helper variable to store all your values as a string, and
then pass it
to prepared statement, it works for me with IN( ) and I think will work
as well for ANY

example code:

String categories = "";
for( int i = 0; i < someCategoryIDs.length; i++ ) {
if( i > 0 ) { categories = categories + ","; }
categories = categories + " " + someCategoryIDs[i];
}

pstmt = connection.prepareStatement( SELECT * FROM catalog WHERE cat_id
IN (" + categories + ") "

Hope it helps

Best Regards,
Pavel Fokin,

Software Engineer,
www.openvillage.info