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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189762 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
