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
