Re: qualifier to check for empty toMany

2011-05-16 Thread Fred Wells
Thanks John, I'll look into Houdah's -fw From: John Huss To: Fred Wells Cc: webobjects-dev@lists.apple.com Date: 05/13/2011 12:13 PM Subject: Re: qualifier to check for empty toMany Yeah, that's true, me too. I actually have used the Houdah one more

Re: qualifier to check for empty toMany

2011-05-13 Thread John Huss
this qualifier > (generates primary key column instead of foreign key), i've corrected it in > my workspace. > > But i'm curious to hear from the others, is there someone else using this > qualifier successfully ? > > > It looks like a bug to me. I mix the Won

Re: qualifier to check for empty toMany

2011-05-13 Thread Chuck Hill
ace. > > But i'm curious to hear from the others, is there someone else using this > qualifier successfully ? > It looks like a bug to me. I mix the Wonder and Houdah qualifiers, and I don't recall which one I have used for this in the past or where I used

Re: qualifier to check for empty toMany

2011-05-13 Thread Alexis Tual
There's a simple way if you have a A ->> B, to fetch all the A's having no B's : EOQualifier qual = ERXQ.isNull(A.TO_BS_KEY + "." + B.ID_KEY); Beware, the to-many relationship must be of type "Left Outer" in your model Hope it helps. Alex Le 11 mai 2011 à 23:29, Fred Wells a écrit : > Hey all

Re: qualifier to check for empty toMany

2011-05-12 Thread Alexis Tual
t in my workspace. But i'm curious to hear from the others, is there someone else using this qualifier successfully ? Hope it helps, Alex > > EOQualifier qual8 = ERXQ.and(qA,qB,qC,qD,qE); > > > > From:A

Re: qualifier to check for empty toMany

2011-05-12 Thread Fred Wells
nd(qA,qB,qC,qD,qE); From: Alexis Tual To: John Huss Cc: Fred Wells , webobjects-dev@lists.apple.com Date: 05/11/2011 05:22 PM Subject:Re: qualifier to check for empty toMany Hi, John is right, if you have A ->> B, this should work : EOQualifier q

Re: qualifier to check for empty toMany

2011-05-11 Thread Alexis Tual
Hi, John is right, if you have A ->> B, this should work : EOQualifier qual = new ERXExistsQualifier( ERXQ.isNotNull(B.A_FK_KEY) , A.TO_BS_KEY); ERXFetchSpecification spec = new ERXFetchSpecification(A.ENTITY_NAME, qual, null); (not tested though) hope it helps Alex Le 12 mai 2011 à 00:00,

Re: qualifier to check for empty toMany

2011-05-11 Thread John Huss
I think you can do this with ERXExistsQualifier and a Not qualifier. John On Wed, May 11, 2011 at 4:29 PM, Fred Wells wrote: > Hey all, > Maybe I missed something but is there a way to construct a qualifier that > check that a toMany relationship is empty? Simply putting in "toMany =%@, > new NS

qualifier to check for empty toMany

2011-05-11 Thread Fred Wells
Hey all, Maybe I missed something but is there a way to construct a qualifier that check that a toMany relationship is empty? Simply putting in "toMany =%@, new NSArray(new Object[] {NSKeyValueCoding.NullValue}doesn't do it because it tries to check across the join table which results in no obje