Yeah I would definitely start with a smaller file while testing.. maybe 5-10 rows and make sure things are working before trying it on a 5 million row file.
Also the query idea... I would use Select * from table where rownum < 2 I believe using the max rows happens after the query.. So CF loads all records and then truncates the 1.. so use rownum if possible. On Fri, 3 Dec 2004 11:21:28 -0500, Dave Carabetta <[EMAIL PROTECTED]> wrote: > On Fri, 3 Dec 2004 10:37:54 -0500, Joe Rinehart <[EMAIL PROTECTED]> wrote: > > > > Yep - this should get you started: > > > > <cfscript> > > filename = "/path/to/file.csv"; > > fileReader = createObject("java", "java.io.FileReader"); > > fileReader = fileReader.init(filename); > > lineReader = createObject("java","java.io.LineNumberReader"); > > lineReader = lineReader.init(fileReader); > > > > line = lineReader.readLine(); > > > > /* this'd keep reading in lines > > while (isDefined("line")) { > > lineCount = lineCount + 1; > > > > // do something here with the data in variable line > > > > line = lineReader.readLine(); > > } > > */ > > </cfscript> > > > > <cfoutput>#line#</cfoutput> > > > > Shouldn't there be a .close() statement in there somewhere at the > bottom? Otherwise you're going to have tons of open files on your > system (I learned this one the hard way!!). > > Regards, > Dave. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186091 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54