can you sort your query by the depth? thats the easiest way because you can just loop over the query adding a node at a time. (group by parentFolder order by depth) When you order by depth you don't need to worry if the parrent exists in the XML DOM yet because the parent will always apear before the child in the query. Otherwise you'll need to find the root create it, find the children of root, create them, find their children... etc. (you'll need either a recursive function or a whole bunch of loops
On 8/23/05, Paul Hastings <[EMAIL PROTECTED]> wrote: > Larry Lyons wrote: > > Paul, > > > > You could try converting the query to XML using Nathan Dintenfass's > > QueryToXML udf, http://www.cflib.org/udf.cfm/querytoxml. > > thanks but that's the first place i checked actually. it's not the > conversion to XML that's my problem it's the structure that cftree will > swallow via remoting that i need to work out in my XML challenged brain. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216093 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
