Just a quick thought, but I don't think CF would have any problems with your commas or brackets as long as your query returns good string values. Can you play with the query outside of CF until you get it formatted well?
-----Original Message----- From: Ted Barker [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 29, 2005 7:00 AM To: Dallas/Fort Worth ColdFusion User Group Mailing List Subject: [DFW CFUG] CFMAIL Q: Importance: High I have been using years old code for newsletter mailings. My task today is to upgrade my emailer which sends out about 34k of email. I have a simple flat file table of subscribed users that I use to populate the mailer via a <cfquery>. The key fields are: #Firstname# #Lastname# #Email# All fields: VALUES ('#TITLE#', '#FIRSTNAME#', '#LASTNAME#', '#SUFFIX#', '#EMAIL#') My task is to concatenate them for the format "DisplayName" [EMAIL PROTECTED] I don't want to run into problems with brackets or surrounds "(" as thousands of my entries have nicknames bracketed by ( xxx ), eg: Firstname: James F. (Jack) Lastname: Johnson, Jr. LTC USA (Ret) === Q: Can I wrap the field nickname brackets with quote marks for the mailer and not cause problems with CFMX 7 ? Q: I have a lot of Dpt of Defense names or other governmental names that have names that are quite complex. Sure all of you have traveled that path, eg: Vencill, Beverly Ms. USASMDCK, CIV [EMAIL PROTECTED] Will comma's inside the wrapper create any problems? Ted ============================================= Ted Barker: PH: 214.320.0342 The Korean War Project (Online since 1/15/94) http://www.koreanwar.org/ (Website since 2/15/95) ============================================= _______________________________________________ List mailing list Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archive: http://lists1.safesecureweb.com/mailman/private/list _______________________________________________ List mailing list Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archive: http://lists1.safesecureweb.com/mailman/private/list
