• 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
Re: [SOLVED] ERXQualifierInSubquery problem
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [SOLVED] ERXQualifierInSubquery problem


  • Subject: Re: [SOLVED] ERXQualifierInSubquery problem
  • From: Pierre Bernard <email@hidden>
  • Date: Tue, 10 Jul 2007 21:12:28 +0200

Did you check out the InSubQueryQualifier available from my web page: http://www.bernard-web.com/pierre ?

It will soon be folded in my future open source project: Houdah Frameworks

Pierre


On Jul 9, 2007, at 1:19 PM, Miguel Arroz wrote:

Hi!

Ok, I fixed the bug, it wasn't in fact converting from relationship names to database column names. I will setup Wonder in Eclipse today, and submit a patch.

  Yours

Miguel Arroz

On 2007/07/09, at 00:27, Miguel Arroz wrote:

Hi!

I'm trying to use the ERXQualifierInSubquery to solve my complex query problem I described earlier. I almost could make it work, but I'm having a strange problem: the inner query cannot find relationships for the entity.

If I have the entity MyEntity with a toOne relationship to a YourEntity entity, called "yourEntity", that uses the "yourEntityID" foreign key, and do this:

EOQualifier qualifier = EOQualifier.qualifierWithQualifierFormat ("yourEntity = %@", args);
ERXQualifierInSubquery qualifier2 = new ERXQualifierInSubquery ( qualifier, "MyEntity", null, whatever );


When WO tries to generate the SQL, I get an error that says "yourEntity" is not reachable from MyEntity. If, however, I do:

EOQualifier qualifier = EOQualifier.qualifierWithQualifierFormat ("yourEntityID = %@", args);

It works. Apparently, the SQL generation is not substituting the relations names for their foreign key table column names. This becomes a major problem because I need to do stuff like "yourEntity.somethingElse.yetAnotherThing = %s" and it obviously doesn't work.

I never did any SQL generating code in WO, but by looking at the qualifier code, everything seems to be working. Does anyone have any ideia of what may be the problem?

  Yours

Miguel Arroz

Miguel Arroz
http://www.terminalapp.net
http://www.ipragma.com



_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40guiamac.com


This email sent to email@hidden

Miguel Arroz http://www.terminalapp.net http://www.ipragma.com



_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
email@hidden


This email sent to email@hidden

- - - Houdah Software s. à r. l. http://www.houdah.com

HoudahGeo: One-stop photo geocoding
HoudahSpot: Powerful Spotlight frontend



_______________________________________________
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


References: 
 >ERXQualifierInSubquery problem (From: Miguel Arroz <email@hidden>)
 >[SOLVED] ERXQualifierInSubquery problem (From: Miguel Arroz <email@hidden>)

  • Prev by Date: Re: WOLips Ant Build
  • Next by Date: RE: Tutorial for webobjects?
  • Previous by thread: [SOLVED] ERXQualifierInSubquery problem
  • Next by thread: Re: Webobjects-dev Digest, Vol 4, Issue 515
  • Index(es):
    • Date
    • Thread