I've set up an app that takes a CSV file from ACT ("Name", "EmailAddress")
and loops through a query created with CFHTTP (see code snippet below) and
sends each person on the list the email. Part of the loop that does this
checks for a validly constructed email address. If its not validly
constructed then it doesn't send an email but populates a report (with
CFFILE) and reports that back to the business area so that they can rectify
the problem. The process came unstuck when it encountered a name and address
with an apostrophe (I have attached much suspicion to this row). I'm not
sure if it was the apostrophe in the name or the address that caused it but
every row below (and including) that in the CSV file crashed out (I suspect
the apostrophe may have corrupted CF's understanding of the construction of
the CSV file???). Any tips on how I can trap this problem please.<cfhttp url="http://domain_name/loop/#AddressFile#"; method="GET" name="Addresses" columns="Subscriber,Address" textqualifier="""" delimiter="," resolveurl="false"> TIA!!!! ********** Kevin Parker Web Services Manager WorkCover Corporation 08 8233 2548 0418 806 166 [EMAIL PROTECTED] ********** ************************************************************************ This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ************************************************************************ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
