Re: Fetch spec "where not In"
Re: Fetch spec "where not In"
- Subject: Re: Fetch spec "where not In"
- From: "Adam Chan" <email@hidden>
- Date: Wed, 17 Sep 2003 16:58:38 -0600
Sounds like that Contact, Venue, Vendor, Operator, Dealer...will all have
their own seperated pk, and the later four have a fk to Contact. Contact by
my understand more likely represents the abstraction of a person. So a
person (Contact) could happen to be many venues, vendors, operators, dealers
in your system at the same time? If so that actually is a 1 <--> n relation
from Conatct to Venue (n could be zero of course).
----- Original Message -----
From: "Jevon Hills" <email@hidden>
To: "Jonathan Rochkind" <email@hidden>
Cc: "Jevon Hills" <email@hidden>; "Apple WebObjects Dev"
<email@hidden>; "WebObjects Newbies"
<email@hidden>
Sent: Wednesday, September 17, 2003 2:51 PM
Subject: Re: Fetch spec "where not In"
> Acutally We have this table of contacts and we are just beginning to
> produce tables like venue, but there will be others like operator,
> vendor, dealer, etc. these tables esentially only have their
> PrimaryKey and one or two pieces of data, rather than having a table
> which refers to its self over and over.
>
> For example we can have a person as a contact named bob, and bob is
> assocated with the Venue "Drinx". So our contact table has 2 rows.
> One for bob as a person, One for Drinx. and Drinx will also have a row
> in venue. Obviously there is a relationship between Venue and contact
> in that a venue can get it's contact info, but I'm having a hard time
> creating the inverse.
>
> So if I were to get my way here what I want is to query contacts and
> return only bob and not drinks.
>
>
>
> As a question to (EOQualifier.qualifierWithQualifierFormat("venue =
> %@", new NSArray( NSKeyValueCoding.NullValue ) );) I understand what
> you have written, but I'm creating the fetch in EOModeler, so that I
> can use it with a DisplayGroup relatively easily. How would I
> accomplish what you have suggested using EOModeler?
_______________________________________________
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.