At 04:56 PM 1/29/03 -0600, you wrote: >- basically it ignores them. Try ListFix, >http://www.cflib.org/udf.cfm?ID=507, to change the null entries to
Raymond, I looked at this udf - looks great for mid-string changes, however I've got two questions - 1. How do I include this udf into the loop below 2. does it work for empty spots in the string on the end of a row or just in the middle between two commas? <cffile action="READ" file="c:\inetpub\wwwroot\briona\secure\modernstorage\shop\control\QuantumUpTry.csv" variable="read_file"> <cfloop index="line" list="#read_file#" delimiters="#chr(10)##chr(13)#"> <cfloop from="1" to="3" index="num"> <cfquery name="update_file" datasource="ModernStorageECom"> UPDATE Products SET JPG = '#listgetAt('#line#',2, ',')#', PDF = '#listgetAt('#line#',3, ',')#' where (MFGPartNumber = '#listgetAt('#line#',1, ',')#') </cfquery> </cfloop> </cfloop> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4