> 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.
I don't think SQLXML lets you perform bulk upload with XML from an SQL query, just through COM objects: http://msdn.microsoft.com/en-us/library/ms171806.aspx As you saw earlier, the issue isn't really doing it from CF, but doing it from any SQL interface, since you couldn't run it from Query Analyzer. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:317057 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
