Yeah, I started thinking about that ... there is not a lot of data but I'll probably use a different solution.
Johnny On Jan 15, 2010, at 5:55 PM, Mike Schrag wrote: > this is REALLY non-optimal fetching here, but if it works for you, cool ... > > ms > > On Jan 15, 2010, at 10:53 PM, Johnny Miller wrote: > >> Well at least there is a good reason I didn't find it. >> >> After thinking about the query as SQL I decided to just use the "in" >> qualifier. >> >> i.e. Artist.fetchMG_Artists(ec(), >> Artist.ARTWORKS.in(Artwork.fetchAllMG_Artworks(ec())), so); >> >> Thanks for the help. >> >> Johnny >> >> On Jan 15, 2010, at 4:00 PM, Mike Schrag wrote: >> >>> oh .. actually this is a qualifier in my own code that isn't in wonder. >>> whoops. i think there's a houdah one for this? >>> >>> On Jan 15, 2010, at 8:44 PM, Johnny Miller wrote: >>> >>>> I'm not familiar with that qualifier (but I've sure been looking for it :) >>>> ). Can you please point me in the right direction or provide an example? >>>> >>>> >>>> On Jan 15, 2010, at 3:39 PM, Mike Schrag wrote: >>>> >>>>> isNotNull only really makes sense on a to-one ... you probably want to >>>>> use the to-many count qualifier (or something like it) for a to-many. >>>>> >>>>> On Jan 15, 2010, at 8:38 PM, Johnny Miller wrote: >>>>> >>>>>> Hi Mike, >>>>>> >>>>>> The two entities Artist <->> Artwork >>>>>> >>>>>> The qualifier is Artist.ARTWORKS.isNotNull() >>>>>> >>>>>> The generated SQL >>>>>> >>>>>> <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "SELECT >>>>>> RTRIM(t0.BIO), t0.CREATE_DATE, RTRIM(t0.FIRST_NAME), t0.ID, t0.IMAGE, >>>>>> t0.LAST_MODIFIED, RTRIM(t0.LAST_NAME) FROM ARTIST t0 WHERE t0.ID is not >>>>>> NULL ORDER BY t0.LAST_NAME ASC, t0.FIRST_NAME ASC" withBindings: > >>>>>> >>>>>> Thanks a lot, >>>>>> >>>>>> Johnny >>>>>> >>>>>> >>>>>> On Jan 15, 2010, at 3:21 PM, Mike Schrag wrote: >>>>>> >>>>>>> there's more than one entity at play here ... please include example >>>>>>> entity names and the exact generated sql. >>>>>>> >>>>>>> On Jan 15, 2010, at 8:18 PM, Johnny Miller wrote: >>>>>>> >>>>>>>> Hi, >>>>>>>> >>>>>>>> I'm trying to get a list of entities who has a relationship that is >>>>>>>> not null >>>>>>>> >>>>>>>> so my ERXKey qualifier looks like >>>>>>>> >>>>>>>> entity.relationship.isNotNull() >>>>>>>> >>>>>>>> When I look at the SQL generated it is making sure that the primary >>>>>>>> key of the entity is not null and it is not looking at the >>>>>>>> relationship at all. >>>>>>>> >>>>>>>> Is that the expected behavior or is it a bug with the MySQL plugin? >>>>>>>> >>>>>>>> WO 5.4.3, MySQL, Wonder recent ;) >>>>>>>> >>>>>>>> Thanks in advance, >>>>>>>> >>>>>>>> Johnny >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> _______________________________________________ >>>>>>>> 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/mschrag%40mdimension.com >>>>>>>> >>>>>>>> This email sent to msch...@mdimension.com >>>>>>> >>>>>>> >>>>>> >>>>>> Johnny Miller >>>>>> Kahalawai Media Corp >>>>>> http://www.kahalawai.com >>>>>> >>>>>> >>>>>> >>>>> >>>> >>>> Johnny Miller >>>> Kahalawai Media Corp >>>> http://www.kahalawai.com >>>> >>>> >>>> >>> >> >> Johnny Miller >> Kahalawai Media Corp >> http://www.kahalawai.com >> >> >> > Johnny Miller Kahalawai Media Corp http://www.kahalawai.com
_______________________________________________ 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
