Re: Bad SQL (no SQL!) for derived columns

Subject: Re: Bad SQL (no SQL!) for derived columns

From: Kieran Kelleher <email@hidden>

Date: Sun, 29 Oct 2006 08:49:59 -0500

Delivered-to: email@hidden

check your eomodel column definition.... it is not picking up the column name somehow. Open the model in EOModeler and check there too.

On Oct 29, 2006, at 4:40 AM, Clark Mueller wrote:

Howdy,

i'm having an issue with a project that I've been converting to MySQL (from OpenBase). Something that has come up since testing against MySQL is that the select query for a derived column does not appear to be generating the correct SQL... it generates a blank column name for the derived columns. For example:

"select t0.someAttribute, t0.otherAttribute, ..., t0.<i-wish-a-formula-was-being-inserted-here-but-it's-not>, ..., t1.someAttribute from xyz t0, abc t1"

Obviously the query fails against the database, because no column or calculation has been entered... Any idea what would be causing this? Basic setup is Eclipse, editing the model with Entity Modeler, with the project using Wonder.

Thanks & regards,
Clark
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/email@hidden

This email sent to email@hidden

_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/email@hidden This email sent to email@hidden

References:

>Bad SQL (no SQL!) for derived columns (From: Clark Mueller <email@hidden>)