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
