Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: neutral (asf.osuosl.org: local policy)
Message-ID: <43343919.1060501@Sourcery.Org>
Date: Fri, 23 Sep 2005 10:19:21 -0700
From: Satheesh Bandaram <satheesh@Sourcery.Org>
User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803)
MIME-Version: 1.0
To: Derby Discussion <derby-user@db.apache.org>
Subject: Re: JDBC and WHERE IN clauses
References: <1121180210.30679.ezmlm@db.apache.org>
 <4333AC62.1060008@cibecs.com>
In-Reply-To: <4333AC62.1060008@cibecs.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Don't think you can do this in Derby. However, you can do:

SELECT * FROM Names WHERE ID IN (?, ?, ?)

and bind individual elements of the array to each of the parameters.
This, of course, forces you to know the number of elements of the array..

Satheesh

Tony Seebregts wrote:

> Hi,
>
> Does anybody know of a way to use a PreparedStatement with a WHERE IN
> (?) clause
>
> e.g. SELECT * FROM Names WHERE ID IN (?)
>
> where the parameter is replaced by an array of e.g. int's ?
>
> regards
>
> Tony Seebregts
>
>
>
>