PreparedStatement and IN Operator ???

Thread view:

Frank - 16 Jun 2004 12:36 GMT

Hi ng,

i created a SQL statement that uses the IN operator.
How can i use that statement in a PreparedStatement?

SELECT FROM USER WHERE NAME IN (?)

Which setter do i have to use for a list like e.g.
? = 'Smith', 'Wesson'

ps.setString(1, "'Meier', 'M?ller'") doesn't work, that would bei
SELECT FROM USER WHERE NAME IN (''Meier', 'M?ller'')

Can i use setArray()?

Frank

Reply to this Message

Lee Fesperman - 16 Jun 2004 22:32 GMT

> Hi ng,
>
[quoted text clipped - 10 lines]
>
> Can i use setArray()?

Generally, ? parameters can only be used with scalar data values (single values). Some
JDBC drivers may support alternate forms or setArray().

Signature

Lee Fesperman, FirstSQL, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)

Reply to this Message

Lionel - 17 Jun 2004 09:57 GMT

> Hi ng,
>
[quoted text clipped - 8 lines]
> ps.setString(1, "'Meier', 'M?ller'") doesn't work, that would bei
> SELECT FROM USER WHERE NAME IN (''Meier', 'M?ller'')

create your request like this and it will work fine:
SELECT FROM USER WHERE NAME IN (?,?,?,...........)

or try hibernate.

Reply to this Message

PreparedStatement and IN Operator ???

Free Magazines