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 ([email protected]) >>>>>>> Help/Unsubscribe/Update your Subscription: >>>>>>> http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40mdimension.com >>>>>>> >>>>>>> This email sent to [email protected] >>>>>> >>>>>> >>>>> >>>>> 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 ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
