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 > > > > > > > _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
