If the user you are connecting as has the power, you can issue the LOAD DATA command from within a cf query, I think, which would probably be the easiest.
HSSQLDB is a pure java database- With HSSQLDB, you can download all the CSV files into one directory, and then run normal SQL commands against them- but it looks like you've got something similar working already. No need to get all complicated, I think Janet is bang on about using the LOAD DATA command. It would certainly be the fasted way to get it into MySQL! On 2/28/07, Deepak Gupta wrote: > The load data query can only be used on SQL prompt, i think. I will try it > though using > stored proc or directly but i read that somewhere tht we can only run on > prompt > > I thought load data had been around since version 4. Am I wrong? I > > was thinking you could use load data to do the import and skip the > > read query and looping altogether. > > > > If you don't think that would work, take a look at Dinner's suggestion > > above. > > > Janet ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271090 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
