Doug Brown wrote: > 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> > You could do this...
SELECT categories.cat_id,categories.category,categories.parent_id FROM categories WHERE categories.parent_id = <cfqueryparam cfsqltype="cf_sql_integer" value="#cat_id#"> ORDER BY CASE WHEN categories.category = 'Other' THEN 1 ELSE 0 END, categories.category ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:254511 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
