Re: Fetch spec "where not In"[MORE]
Re: Fetch spec "where not In"[MORE]
- Subject: Re: Fetch spec "where not In"[MORE]
- From: Jevon Hills <email@hidden>
- Date: Wed, 17 Sep 2003 16:11:48 -0600
WHEN I RUN the following query in my sql tool: Select * from
BusinessAssociate WHERE businessAssociateID NOT IN (Select
businessAssociateID from Venue) I get precisely what I want. How do I
get this in EOModeler???
On Wednesday, September 17, 2003, at 02:13 PM, Jonathan Rochkind wrote:
> It depends on exactly how you have it modeled (and it can get tricky,
> depending), but the first thing to try is simply:
>
> EOQualifier.qualifierWithQualifierFormat("venue = %@", new NSArray(
> NSKeyValueCoding.NullValue ) );
>
> That is, where the "venue" relationship is null.
>
> If that doesn't do it for you, tell us more about your model/schema.
> How is the relationship from Venue to Contact defined.
>
> It sounds like the real "meaning" there is an inheritance one. Since
> you said Venue _is_ a Contact, but not all Contacts are Venues. You
> _could_ actually model this inheritance, so Venue would actually _be_
> a Contact, instead of having a relationship to Contact. But it doesn't
> sound like you've done so, and you don't neccesarily need to, it's an
> added level of complexity in your model.
>
> --Jonathan
>
> At 01:40 PM 9/17/2003 -0600, Jevon Hills wrote:
>> I have two tables in a one to 0 or 1 relationship. Contact and Venue.
>>
>> Essentially a Venue is a contact, but a contact is not necessarily a
>> venue
>> contact 1<-->0..1 Venue
>>
>> I want to create a fetch which gets all contacts which are not venues.
>> How can I do this?
>>
>>
>>
>> Jevon K. Hills
>> Developer - Zymeta Media Promotion Systems
>> _______________________________________________
>> 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.
> _______________________________________________
> 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.
>
>
Jevon K. Hills
Developer - Zymeta Media Promotion Systems
_______________________________________________
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.