IF i use a cat_parent_id in my table i can use the following query to display each level...
SELECT cat_ID, cat_title, cat_sort_order FROM categories WHERE cat_parent_id = <cfqueryparam cfsqltype="cf_sql_integer" value="#URL.parent_id#"> ORDER BY cat_sort_order knowing that the top level categories have a cat_parent_id of 0. also... if i move a category, i can replace the cat_parent_id with the new id (or 0 if i have moved to the top) and then perform a rebuild of the left and right values. sorry, i am really thinking aloud at the moment, but i am really interested in the concept and wish to make sure i am using only the columns needed to perform what i need to do. mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231060 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
