Re: ANY subquery and PreparedStatements

how about

public String setCommand(String table,String filedName1)
{
StringBuffer sb = new StringBuffer("Select * from table ");
sb.append(table);
sb.append(" where ");
sb.append(filedName1);
sb.append(" any (?)");
return sb.toSting();
}

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?
>
> --
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org