It does; however, the query results are a bit odd (at least they were for us - the way the "rows" were broken up). So after you do a query with the FOR XML, you might want to do a cfdump before trying to process the xml (meaning <cfdump var="#query#"/>).
Rob -----Original Message----- From: Samuel R. Neff [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 12:03 PM To: CF-Talk Subject: Re: CF 2 XML MS SQL 2000 has a FOR XML EXPLICIT syntax for creating custom XML from queries. A little learning curve but once you get over it that easy to use and very powerful. At 02:38 PM 1/8/2003, you wrote: >Hi there, >are there any tools out there that will convert a structure/query set into >an XML document using a given schema? >Tks/Rgds ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4