They all have email addresses, I just don't know why it's throwing the validation error on the CFMail 'TO'. I want to send out to about 100 different addresses, is there any issues with that?
-----Original Message----- From: Billy Cox [mailto:[email protected]] Sent: 2009-01-05 4:07 PM To: cf-talk Subject: RE: Personalizing a CFLoop - validation error How about amending your query to only return results that have an email address? -----Original Message----- From: cfcom [mailto:[email protected]] Sent: Monday, January 05, 2009 3:01 PM To: cf-talk Subject: RE: Personalizing a CFLoop - validation error I added four columns to database; 'recip_firstname, recip_lastname, recip_title, recip_email'. Now all the 'sender and recipient' data in the same table of db, but I keep getting an error: //Attribute validation error for tag CFMAIL. //The value of the attribute TO is invalid. The length of the string, 0 //character(s), must be greater than or equal to 1 character(s). <cfinsert datasource="mynamedsn" tablename="mytablename" formfields="sender_firstname, sender_lastname, sender_email, sender_address, sender_city, sender_state, sender_zip, sender_time, sender_date, sender_ip, sender_msgType"> <CFQUERY NAME="GetRecipients" datasource="mynamedsn" > SELECT * FROM mytablename </CFQUERY> <cfloop query="GetRecipients"> <cfmail to="#GetRecipients.recip_email#" from="#form.sender_email#" subject="My Message To You 2009" > #sender_date# Dear #GetRecipients.recip_title# #GetRecipients.recip_firstname# #GetRecipients.recip_lastname# This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. Yours truly, #form.sender_firstname# #form.sender_lastname# #form.sender_address# #form.sender_city#, #form.sender_state# #form.sender_zip# #form.sender_email# </cfmail> </cfloop> -----Original Message----- From: [email protected] [mailto:[email protected]] Sent: 2009-01-05 3:17 PM To: cf-talk Subject: RE: Personalizing a CFLoop I would just do something like this then. <CFQUERY NAME="GetRecipients" DATASOURCE="#DataSource#"> SELECT * FROM Recipients </CFQUERY> <cfloop query="GetRecipients"> <cfmail to="#GetRecipients.Email#" from="#sender_email#" subject="My Message To You 2009" > #sender_date# Dear #GetRecipients.Name# This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. This is my message to the recipient. Yours truly, #sender_firstname# #sender_lastname# #sender_address# #sender_city#, #sender_state# #sender_zip# #sender_email# </cfmail> </cfloop> -----Original Message----- From: cfcom [mailto:[email protected]] Sent: Monday, January 05, 2009 2:21 PM To: cf-talk Subject: RE: Personalizing a CFLoop Yes, it is stored. I can store form_sender and recipients if necessary -----Original Message----- From: [email protected] [mailto:[email protected]] Sent: 2009-01-05 2:13 PM To: cf-talk Subject: RE: Personalizing a CFLoop Is the recipient data stored in a table by chance? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317420 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
