Re: DisplayGroup/ERXFlickrBatchNavigation question - Wonder bug?
Re: DisplayGroup/ERXFlickrBatchNavigation question - Wonder bug?
- Subject: Re: DisplayGroup/ERXFlickrBatchNavigation question - Wonder bug?
- From: Chuck Hill <email@hidden>
- Date: Mon, 28 Dec 2009 12:06:51 -0800
And the qualifiers are what controls what SQL is generated. It could
also be the way the DG is combining the qualifiers internally. Maybe
try creating the OR externally and just setting one combined qualifier
on the DG. If that does not work, consider dropping the ERXKey stuff
and build it using the Wonder qualifiers directly. You might need to
re-state the query.
Chuck
On Dec 28, 2009, at 10:20 AM, Andrew R. Kinnie wrote:
Also, the reason I point out the distinct/sorting issue is that the
generated SQL uses an order by in the outer select, and if you add
distinct in the inner select, it's not including the attributes
required by the order by, but only the id attribute. Thus, Oracle
raises an error, because the distinct select must contain all the
attributes used by the order by. If I run the sql separately, I get
the same error, and if I add the order by attributes manually to the
SQL, I get the correct result.
Andrew
On Dec 28, 2009, at 12:53 PM, Chuck Hill wrote:
On Dec 28, 2009, at 9:06 AM, Andrew R. Kinnie wrote:
As a followup, I get the correct number of rows if I comment out
any code which sorts the displayGroup using attributes other than
the id column of the entity populating the displayGroup.
Without sorting, and with setUsesDistinct(true); I get 23 rows.
Navigation works.
If I then try to sort the displayGroup (using in this case the
entity's lastname then firstname attributes) I get the oracle
error, because the inner most select statement generated by Wonder/
EOF has a distinct, but is trying to orderby attributes that are
in the outermost select but not the inner most select where the
distinct statement is.
Is this a bug in Wonder where setUsesDistinct(true); does not work
with sorting?
Am I missing something?
What is the qualifier? If you are using one of the Wonder
qualifiers, you may have found a bug or may be using them
incorrectly.
Chuck
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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