Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: "in" clause using binds / oo4o / asp

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

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


tojo <Tojo_at_hotmail.com> wrote in
news:MPG.1a89c8b8c8cbbbce9896d3_at_news.t-online.de:

>> 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
>>

> If the amount of values is unknown, you may want to insert them into a
> (temporary) table and use either a normal join or:
> 
>   select ... from ... where x in (select x from temp_table);  

Hi Tom,

unfortunately not possible, read only access. There must be a standard ASP & oo4o method for this using collections / casting perhaps?

Thanks Received on Tue Feb 03 2004 - 09:42:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US