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

Reply via email to