>- see footer for list info -< Glad to hear that, Lee, and thanks for sharing. Another benefit is that I think anyone looking at the code would also find it a lot easier to read. :-)
/charlie http://www.carehart.org/blog/ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lee Fortnam Sent: Tuesday, September 12, 2006 7:03 PM To: 'Coldfusion Development' Subject: RE: [CF-Dev] Import of 10k records from a tab delimited txt >- see footer for list info -< And the Winner is!!!! Charlie! The system is processing the 10K records in sub 5 seconds including the insert to the DB!!!!!! Nice one Charlie. Final code is as follows: <cfxml variable="x"> <Contacts> <!--- Loop through array doing row creation ---> <cfloop from="1" to="#recordsToDo#" step="1" index="Count"> <cfset tempNumber = #REReplace(ListGetAt(csvArray[count],3,chr(9)),"[^0-9]","","ALL")#> <cfset tempType = #ListGetAt(csvArray[count],2,chr(9))#> <snip> _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
