XML is supported in SQL2K via the SQLXML install. I couldn't get this to work via the cfquery so I did it in a round about way. I created a .vbs file and then use cfexecute to run cscript.exe and pass the path of the .vbs file to it and it works like a charm.
If anyone knows how to actually do this via a cfquery I would still LOVE to know how. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317055 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
