Re: Struggling with qualifiers involving sets
Re: Struggling with qualifiers involving sets
- Subject: Re: Struggling with qualifiers involving sets
- From: Art Isbell <email@hidden>
- Date: Sun, 3 Aug 2003 18:04:13 -1000
On Sunday, August 3, 2003, at 05:52 PM, Arturo Pirez wrote:
Not always. What about
select a from b where col in (select c from d where col2 = e)
If that subselect returns more than a few dozen things then ORing is
going to be a major
pain.
Not really.
How would you address the above?
Iterate over the subselect result set creating an EOQualifier for each
"c" value. Add each qualifier to an array. Use the array as an
argument to an EOOrQualifier. I wouldn't consider this to be a major
pain.
And can you do it without using something from
Project Wonder? :)
Sure (see above).
Aloha,
Art
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.