1) If the udf was in a file called strlib, you could cfinclude the file. Or you can cut and paste the code into your file below, or into your Application.cfm file. To call the UDF, you call it like any other BIF (built-in function).
2) It _should_ handle them as well - if not, let me know. ;) ======================================================================= Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email : [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 30, 2003 8:13 AM > To: CF-Talk > Subject: ListFix UDF Question > > > 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\cont > rol\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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
