If you have an entity with no exposed properties incorrect SQL gets generated (mysql + plugin). I have an entity who's sole purpose is to map between two other entities, it contains no data itself, just two one:many relationships, and an id field, so three fields in all (id, and two for the relationships). This causes SQL to be generated 'select t0.relationship1Id, t0., t0.relationship2 FROM ...'. If I add a dummy data property to the entity you get 'select t0.relationship1Id, t0.dummy, t0.relationship2 FROM ...' generated. Seems that an assumption is being made that at least one exposed property will exist for the EO. Is this likely to be the plugin or the driver or WO itself?
Thanks Mark _______________________________________________ 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
