>It doesn't make any difference whether The Order By is in the >inner or outer select. The inner select is really a view, so you >can order the view, or the select statement running against the >view. Same results. The results are weird though.
It is odd. It seems to be ordering the pages alphabetically and by case, but not the total returned list, so I'm getting in sets of 10 page 1: agency 01,agency 02,... agency 09,daniel's agency page 2: agency 10,agency 11,...agency 20 which then pages through agencies to page 6 where I see: page 6: Agency 01, Agency of Imm..., Sesame Av, agency 01, agency 50,... doorknobs So each page looks alphabetized in a case-sensitive way (bummer), but I'd rather the total list be alphabetized and then just grabs from that. But I guess you know that. > > >>Can you show us what Oracle is getting? the query from the debug output? >> >> >> >>On Thu, 27 Jan 2005 14:27:14 -0400, daniel kessler <[EMAIL PROTECTED]> wrote: >>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192070 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
