cffile loop file sql insert
Ohh ok so this was fun, I got to create a page to insert a few hundred thousand records. Since the data was coming from sql 2008 and had to move over to sql 2005. So after generating a file in sql that ended up being about 13 gigs of sql statements. Just in case people need to know you can't actually open files that large in pretty much anything... I ended up downloading LTF Viewer from http://www.swiftgear.com/ltfviewer/features.html
I highly recommend it.
Anyways the code for reading very very large files with cfloop file
0 responses to “cffile loop file sql insert”