On Jun 23, 2009, at 12:10 AM, Tim Worman wrote:
One other avenue to pursue is whether EOKeyValueQualifier is
suitable for the sort of query you are doing:
EOKeyValueQualifier
("primaryapprovers.employee",EOQualifier.QualifierOperatorEqual,
someEmployee)
Maybe
ERXExistsQualifier
(EOKeyValueQualifier("employee",EOQualifier.QualifierOperatorEqual,
someEmployee), "primaryapprovers")
I just wanted to follow up and say that this contraption qualifier
works. Thanks for a workable solution Chuck. If I ever make a
WOWODC, I am now up to about 6 beers owed.
I suspected that might be it. Several of the qualifiers only generate
the correct SQL within a set of boundaries and none tell you when you
stray outside. EOKeyValueQualifier and to-many relationships are
often problematic. That is one of the reasons these other qualifiers
were created.
Chuck
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com