Whoops sorry, that should be "add a column to your CATEGORIES table" not products table as in my first post.
Then of course you would add "ORDER BY SortOrder" to your query. -- Josh > ----- Original Message ----- > From: "Doug Brown" <[EMAIL PROTECTED]> > To: "CF-Talk" <[email protected]> > Sent: Wednesday, September 27, 2006 11:06 AM > Subject: Help displaying a query result > > >>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:254481 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
