For the 'fancy' way, you could always do, after the query: <cfset queryAddRow(get_child_categories) /> <cfset querySetCell(get_child_categories, "cat_id", 9999) /> <cfset querySetCell(get_child_categories, "category", "Other") /> <cfset querySetCell(get_child_categories, "parent_id", 1) />
That would stick it at the end =) Chris -----Original Message----- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 27, 2006 2:26 PM To: CF-Talk Subject: [SPAM] Re: Help displaying a query result As a long term solution, you might want to add a column to your products table called "SortOrder" or "Priority" which contains the actual order you want the query to output. This way you are not stuck to any particular way of sorting (by id, name etc.) You could make the "Other" category 99999 or something suitably high so it will always be last. Then in your admin section you'll want to be able to modify that column's value so you can change the order if necessary. In lieu of that, I'm sure some folks on here will have a fancy way to get that "Other" category to come out at the end. -- Josh ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254474 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
