Re: "in" clause using binds / oo4o / asp

From: John <Nothanks_at_noaddress.com>
Date: Tue, 3 Feb 2004 13:47:48 +0000 (UTC)
Message-ID: <Xns94848C89B2C5ENothanksnoaddresscom@127.0.0.1>

"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in news:PtNTb.209118$I06.2316754_at_attbi_s01:
> "John" <Nothanks_at_noaddress.com> wrote in message
> news:Xns948488D28205BNothanksnoaddresscom_at_127.0.0.1...

>> Is it possible?
>>
>> seems to be quite a negative vibe :)
>>
>> Oracle 8.1.7.latest SE ideally!
>>
>> Thanks

> Yes, why would it not be?
> select ... from ... where x in (:hvone,:hvtwo,:hvthree); for 3 elements
>
> This won't work

>:hvone='a,b,c'
> select ... from ... where x in (:hvone); as an equivalent to above.

Perhaps I needed to state that the amount of values in the "IN" is unknown. Hence I want to pass in an array, not a list of binds.

Cheers Received on Tue Feb 03 2004 - 07:47:48 CST