Tried this, and it works (kind of) When you click on the parent category, you are taken to the child category where you can again drill down further to the child of child category. In this case the code given displays two (other) categories. Kind of wondering if this is even possible. Thanks for all the help, but I was also thinking that since there is several categories and they all have their own "other" category, that it would not be possible to have say a 9999 parent_id for all of them since they are associated with their parents. Arghhh....There is always something that limits you. What about a arrays?
----- Original Message ----- From: "Peterson, Chris" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Wednesday, September 27, 2006 12:51 PM Subject: Re: Help displaying a query result > 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:254540 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
