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 > > >
_______________________________________________ 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