• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
 

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Bad SQL (no SQL!) for derived columns
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Bad SQL (no SQL!) for derived columns


  • Subject: Bad SQL (no SQL!) for derived columns
  • From: Clark Mueller <email@hidden>
  • Date: Sun, 29 Oct 2006 02:40:00 -0700

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:

This email sent to email@hidden

  • Follow-Ups:
    • Re: Bad SQL (no SQL!) for derived columns
      • From: Kieran Kelleher <email@hidden>
  • Prev by Date: Re: WWDC movies on iTunes
  • Next by Date: Re: WWDC movies on iTunes
  • Previous by thread: Re: WWDC movies on iTunes
  • Next by thread: Re: Bad SQL (no SQL!) for derived columns
  • Index(es):
    • Date
    • Thread