When in doubt, ask Ben Nadel(or check his blog)... Words to live by I had the same issue, huge variable XML file, lots of variations, had a hell of a time making it work in SQL Server due to the complexity
Used this, works amazingly well, all things considered, executes very quickly http://www.bennadel.com/blog/1345-Ask-Ben-Parsing-Very-Large-XML-Documents-In-ColdFusion.htm =] On Mon, Feb 14, 2011 at 5:15 PM, Casey Dougall < ca...@uberwebsitesolutions.com> wrote: > > On Mon, Feb 14, 2011 at 7:07 PM, Matt Robertson <websitema...@gmail.com > >wrote: > > > > > Client is running mySQL, But a SQL Server could probably be arranged > > if we have to. Kind of a painful investment for them, though. > > > > > > Well seems there is support for this in mysql as well but examples use > something simular to BulkInsert where the xml file is on the MySql Server. > > http://dev.mysql.com/tech-resources/articles/xml-in-mysql5.1-6.0.html > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342225 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
