Has anyone using Celko's Nested Set model figured out a way to arrange the categories either alphabetically or some other way besides just the order they are added to the tree? I was going to use that Nested Set model on one of my upcomming projects, but I'm going to need the ability to sort the different categories by something other than just the order they are added. For example: Employees Bob Title Job Sara Title Job Adam Title Job I want to sort it maybe alphabetically, but still maintain the tree... Employees Adam Job Title Bob Job Title Sara Job Title How would I do this? Is it even possible using the Nested Set model? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists