>i am so XML challanged, can one of your XML guri send me in the right >direction? i have a query of folders (folder name, number of items, >parent folder) that i push into cftree (after re-sorting it via the QofQ >below). works fine. but i need to update the cftree via remoting which >wants XML. > ><cfquery name="resorted" dbtype="query"> > SELECT name,fullname,parentFolder,totalMessages > FROM results.folders > ORDER BY fullname,parentFolder ></cfquery> > >any idea of cfoutput to get XML that cftree will swallow which i guess >is something like the following? > ><INBOX> ><folder a /> ><folder b /> ><folder c /> > <folder d /> > <folder e /> ></folder c> ></INBOX>
Paul, You could try converting the query to XML using Nathan Dintenfass's QueryToXML udf, http://www.cflib.org/udf.cfm/querytoxml. hth, larry ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:216060 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
