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