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