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: oo4o binding values to "in" clause

Re: oo4o binding values to "in" clause

From: Jim Kennedy <kennedy-down_with_spammers_at_attbi.com>
Date: Thu, 26 Jun 2003 14:56:03 GMT
Message-ID: <7QDKa.25735$nG.28801@rwcrnsc51.ops.asp.att.net>


I think there is some info at asktom.oracle.com. I did it by having multiple bind variables for the in clause or by having the values in a table.
Jim

-- 
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"Jack" <never_at_inamillion1.com> wrote in message
news:Xns93A693C2699D2neverinamillioncom_at_127.0.0.1...

> Hi Gods of Oracle,
>
> I'm in need of something like:
>
> select * from colourtable
> where colour in :somecolours
>
> Obviously :somecolours would be ('red','blue','green') in regular SQL but
> using oo4o (asp in particular (eww)) I imagine I need to create some kind
> of collection variable object first and pass that into the bind.
>
> Any one able to point me in the right direction? ASP or VB source would
be
> most welcome :-)
>
> Thanks
> Jack.
Received on Thu Jun 26 2003 - 09:56:03 CDT

Original text of this message

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