<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#"> ORDER BY categories.category asc </cfquery>
This looks about right. Teddy On 9/27/06, Doug Brown <[EMAIL PROTECTED]> 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> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:254464 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
