Follow up for discussion:
I experimented with variations of the use of quotes or surrounds
for email addresses. I performed a query to concatenate the name
fields: lastname, firstname, title, suffix, email.
First I tried () for the names which resulted in many names
having this:
(Firstname MI (Nick) Lastname) <[EMAIL PROTECTED]>
Some lastnames had Jones (nee Adams) for example resulting in:
(Firstname MI (Nick) Lastname (Nee)) <[EMAIL PROTECTED]>
That resulted in the CF query display to strip the email address
from view but it appeared to send and arrive AOKAY.
Wanting to get the name displayed and email displayed for my
worrisome self, I re-queried with quote marks for all names.
Voila, all went well, to my knowledge.
"Firstname MI (Nick) Lastname (Nee)" <[EMAIL PROTECTED]>
Now all I have to do is set some <cfset> commands and try a
complet <cfquery> <cfmail> routine.
Once again, thanks to the CFUG folks for assistance.
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)
=============================================
----- Original Message -----
From: "Lewis, David" <[EMAIL PROTECTED]>
To: "'Dallas/Fort Worth ColdFusion User Group Mailing List'"
<[email protected]>
Sent: Tuesday, November 29, 2005 9:23 AM
Subject: RE: [DFW CFUG] CFMAIL Q:
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
_______________________________________________
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
DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/
