From: Chuck H. <ch...@gl...> - 2008-12-05 23:10:41
|
On Dec 5, 2008, at 3:01 PM, casey lawlor wrote: > Hello I am trying to do an EOQualifier using erxkeys but I am having > some trouble. In my db I have an address table that has a one way > relationship to a states table. I am trying to traverse this path > to filter on the state. Here is the code that I have. > > "advisorsDisGr > .setQualifier > ((EOQualifier)Advisors.ADDRESS.dot(Address.STATE).eq(stateToFilter));" > > where advisorsDisGr is a displaygroup contianing all the advisors > from advisors table. Advisors has a relationship to address which > then has a relationship to states. > > This code does run without any errors but it filters out everything > and obviously does not give the desired results. I don't know how to > get from my advisor table through the path to the states table. I > am pretty new to this so I'm sorry if This doesnt make sense. You probably have objects in two different editing contexts. Is stateToFilter().editingContext() the same as the one used by the objects in advisorsDisGr? 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 |