If you wanted to sort them by something other than the lexigraphical values of the strings (their index in the character set) -- which is what CF Server does natively. It's never an issue if you only ever deal with english, but in this case I was working on a query-sorting function which would use Java collation so that for instance characters accented with umlauts in a query containing german text would be sorted in an order that german viewers would expect, rather than being sorted to the end of the query.
> I don't get it? > Why wouldn't you just do: > <cfquery name="rs" dbtype="query"> > select firstname,lastname,middlename from rsname > order by lastname, firstname, middlename > <cfquery> > I don't get what the sort_ columns are > -----Original Message----- > From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] > Sent: Sunday, January 09, 2005 5:21 PM > To: CF-Talk > Subject: query of query - order by columns not dropped - > bug? > Has anyone else noticed a query of query including columns > in the > order by clause in the returned query even when they are > not included > in the select list? I.e. > <cfquery name="rs" dbtype="query"> > select firstname,lastname,middlename from rsname > order by sort_lastname, sort_firstname, sort_middlename > <cfquery> > When I execute this query the column list of the result is > firstname,lastname,middlename,sort_firstname,sort_lastname > instead of firstname,lastname,middlename as it ought to be > just wondering if anyone else has seen this... I'm using a > second > query of query to work around it -- though I hate to add > the overhead > to do that. s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189766 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
