I don't think it's necessary for the loop to work, but at the time I think I ended up putting listFix() on everything coming out of the CSV I was parsing. Taking it out doesn't change anything.
~Steve http://goodcf.instantspot.com/blog C S wrote: >> The error crops up when the loop encounters a field that has null data. >> I am using ListFix, and i thought that this would solve the problem, but >> it doesn't. >> <cfloop index="record" list="#ListFix(fileData)#" delimiters="#chr(9)#"> >> > > Is that the correct loop logic? Should you not be splitting on new lines, > then using ListFix on each row? > > <cfloop index="record" list="#fileData#" delimiters="#theNewLineCharacter#"> > ... skip first 5 rows .. > <cfset fixedList = listfix(record)> > <!--- insert the data into the database table ---> > ... > </cfloop> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299872 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
