I had this awesome tree that now needs a different sort order. This has a table of parents and sub parents and then children. I have it working in this order:
P C //this is P C C C C P C P C C C The parent and child tables have a sort column Now I need the following sort order: P P C C C C P C C //this is last now instead of first P C C C I'm stumped on how to get this sort order and then build it in an XML tree. I know this can be a complex process to show the code so if you could describe just the table schema? In my function, I loop the parents, then loop the children but this requires looping the parents, then looping the sub parents and keeping into account that there may be a child in between parents. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339520 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm