Hi, This has been bugging me for about 3 years now, and I've finally decided to see if I can beat it (er... well see if I can find someone else that can beat it :)
I've got a db table with a typical category heirachy structure: categoryId, parentCategoryId, categoryName, etc.. Given a particular categoryId, is it possible to get the path back to the root category in only one db query? (given that the depth of the category in the structure is unknown). Ian ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188611 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
