If its somethink like a csv then you can setup a Datasource in CF to look at the file and then just call the file via CFQuery.... If it's a csv then you could use CFX_CSVToQuery tag which will convert the file to a Query Object...
Failing that Look for a cfx tag or write a COM object to handle the file so that you know its being processed line by line HTH -----Original Message----- From: Ed Gordon [mailto:[EMAIL PROTECTED]] Sent: 27 March 2002 15:37 To: CF-Talk Subject: CFFILE reads whole file into 1 var? CFFILE READs whole file into 1 var? Is there a limit on the size of the contents of that file? Is there an alternative way to read and process one record at a time in the traditional fashion? I had to parse thru the file looking for CR's and CFLOOP thru the logic. Seems strange, but if that's the way we must do it, when in Poughkeepsie, do as the... nevermind... how do YOU process each record in a flat file? Thanks In Advance Ed Gordon Weekdays: Software Developer Weekends: Fighting Crime as Chicken Man FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists