Re: Fetch spec "where not In"
Re: Fetch spec "where not In"
- Subject: Re: Fetch spec "where not In"
- From: Jonathan Rochkind <email@hidden>
- Date: Wed, 17 Sep 2003 15:13:41 -0500
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.