MSSQL supports two types of FOR XML, FOR XML AUTO and FOR XML EXPLICIT. AUTO creates some default XML. EXPLICIT can be used to create any XML and can be used to make it match a pre-determined schema.
At 12:46 PM 1/8/2003, you wrote: >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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
