I would guess that there is an illegal format of an email address and
cfmail is throwing an exception.

Adam


On Sun, Dec 7, 2008 at 1:44 PM, cfcom <[EMAIL PROTECTED]> wrote:

> My CFloop died, it used to work but now doesn't and I haven't touched the
> code. Any help would be greatly appreciated.
>
>
>
> Thanks
>
>
>
>
>
> <!--- xxxxxxxxxxxxxxxxxxxx insert start xxxxxxxxxxxxxxxxxxxxxxxx --->
>
> <cfinsert datasource="myname_dsn" tablename="mytablename"
>
>                          username="xyz"
>
>                          password="abc"
>
>                          formfields="sender_firstname, sender_lastname,
> sender_email, sender_address, sender_city, sender_state, sender_zip,
> sender_time, sender_date, sender_ip, sender_msgType">
>
>
>
>
>
> <!--- xxxxxxxxxxxxxxxxxxxx query get start xxxxxxxxxxxxxxxxxxxxxxxx --->
>
>
>
> <cfquery name="GetHolidays" datasource="mydsn_dsn" username="xyz"
> password="abc">
>
> SELECT sender_email, sender_firstname, sender_lastname, sender_address,
> sender_city, sender_state, sender_zip, sender_date, sender_time, sender_ip,
> sender_msgType
>
> FROM  Holidays
>
> WHERE sender_email = '#Form.sender_email#'
>
> </cfquery>
>
> <!--- xxxxxxxxxxxxxxxxxxxx query get end   xxxxxxxxxxxxxxxxxxxxxxxx --->
>
>
>
>
>
> <!--- XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX MAIL ACTION
> XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX --->
>
> <cfoutput>#DateFormat(Now(), "mmmm d, yyyy")# </cfoutput>
>
>
>
> <cfset recipients="[EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED],
> [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] ">
>
>
>
>            <cfloop list="#recipients#" index="recipient">
>
>
>
>            <cfmail to="#recipient#" from="#GetHolidays.sender_email#"
> subject="MySubjectName" query="GetHolidays" >
>
>      #getholidays.sender_date#
>
>
>
>
>
>      Dear Jon,
>
>
>
>
>
>      This is my written statement here.
>
>
>
>      Thank you.
>
>
>
>      Yours truly,
>
>
>
>      #GetHolidays.sender_firstname# #GetHolidays.sender_lastname#
>
>      #GetHolidays.sender_address#
>
>      #GetHolidays.sender_city#, #GetHolidays.sender_state#
> #GetHolidays.sender_zip#
>
>      #GetHolidays.sender_email#
>
>            </cfmail>
>
> </cfloop>
>
>
>
>
>
> <!--- XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX MAIL ACTION END
> XXXXXXXXXXXXXXXXXXXXXXXXXX --->
>
>
>
>
>
> 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:316395
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to