Re: qualifier using a relationship
Re: qualifier using a relationship
- Subject: Re: qualifier using a relationship
- From: Art Isbell <email@hidden>
- Date: Tue, 15 Jun 2004 12:25:02 -1000
On Jun 15, 2004, at 12:03 PM, Nathan Dumar wrote:
If I build a fetch spec in the user entity to fetch only the users in
a specific family, using the relationship called family and a family
object (family = $famObj), the SQL generated is "WHERE k_from_family
is NULL" instead of the usual question mark to indicate a variable.
(k_from_family is the foreign key in User.)
That works fine for me over and over again :-) I suspect this SQL is
generated because $famObj is null. Break in the debugger where you set
famObj to verify that it isn't null.
(family.familyKey = $famKey) produces "WHERE family_key = ? AND
k_from_family = family_key." Assuming (yikes!) this will work, I
guess I'll just have to use keys to qualify through a relationship.
Bad form. Shouldn't be necessary.
Aloha,
Art
_______________________________________________
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.