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

