That is probably the solution I was thinking of too, I expect Ben or someone just wrapped it up into a UDF or CFC or posted it on one of the aforementioned sites.
Russ On Tue, Feb 15, 2011 at 12:32 AM, Michael Grant <[email protected]> wrote: > > 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:342229 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
