With all the work you've put into this solution, I hate to even say this, but may I suggest a better way, that will should a lot of headaches?
Create a ODBC Text Datasource to the file one the machine and then just use cfquery to turn it into a query...which you can loop over or whatever else you want. The ODBC Text Driver has never thrown an error on me complaining about invalid entries, and it's blazing fast... Just go the the ODBC Control Panel and create a Text DSN, save the schema.ini in the same folder as your app, and run something like the below query. <cfquery datasource="textsource" name="textqry"> SELECT * FROM [#filename#] </cfquery> voila -- jon mailto:[EMAIL PROTECTED] Wednesday, January 29, 2003, 5:44:13 PM, you wrote: RAB> OK so shoot me in the foot - if my csv file has x records and any RAB> of those records have a BLANK field- this won't work... it comes back RAB> with an error in the loop. Is there any way to force it to fill in a RAB> field with a null? This is especially important with the last record last RAB> field position. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
