How do you generally handle generating hierarchical tree data from a database. Lets say I had a query that returned "*Name, ID, ParentID*" with an indefinite number of nest levels, and I wanted to turn that into a nice xml structure - do you usually peform that transofrmation at the DB layer, the app layer, or is there perhaps an easy Flex function that can take care of that?
The ideal function would take the query and ask for the id and parentid properties to use to recurse through the query, i.e. generateNestedXMLFromFlatQuery(QueryData, ID_ColumnName, ParentID_columnName):XML; Thoughts?
