I have a list of categories, and I want to sort them ascending, but I need to have the category (other) always listed last. Anyone have ideas on how to accomplish this?
IE: Baby Backpacks Baby Carriers and Slings Baby Jumpers Play Pens Vibrating Chairs Other My current query is like so... <cfquery datasource="#request.site.dsn#" name="get_child_categories"> SELECT categories.cat_id, categories.category, categories.parent_id FROM categories WHERE categories.parent_id = <cfqueryparam cfsqltype="cf_sql_integer" value="#cat_id#"> </cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:254453 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
