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
