the problem is CF ignores multiple consecutive delimiters, pretending it is just one delimiter. in CF8 there is a parameter in some list functions to tell cf NOT to ignore empty list elements. before CF8 you have to insert something (like a space) into empty elements in each line of your csv (using replace() or similar function).
hth Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Steve Good 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. I have no control over the csv files, so I need to figure > out a way to accurately input these null fields without throwing an > error. Any ideas? > > ~Steve > http://goodcf.instantspot.com/blog > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:299869 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
