That actually looks like a pretty nice solution if bulkinsert isn't an option.
On Mon, Feb 14, 2011 at 7:24 PM, Alan Rother <[email protected]> wrote: > > 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 < > [email protected]> wrote: > > > > > On Mon, Feb 14, 2011 at 7:07 PM, Matt Robertson <[email protected] > > >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:342227 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
