Marcus, You basically have two choices:
1. extend the timeout in the ColdFusion admin. 2. break up your recordset into smaller groups of data the runs under the timeout. Regards, Phillip B. Holmes -----Original Message----- From: Marcus Whitworth [mailto:[EMAIL PROTECTED] Sent: Sunday, February 06, 2005 9:16 PM To: CF-Talk Subject: cfmail timeout problems Hi, I am trying sending a client newsletter out to about 25000 subscribers using the code below. We are running CFMX 6.1 Enterprise on JRun 4 on Windows 2003. The problem is that every time we try to send the newsletter out, the page times out and an error is thrown. Some perhaps relevant settings in CF Admin are as follows: Timeout Requests After: 90 seconds Maintain connection to mail server: True Mail Spool Interval: 15 seconds Max Delivery Threads: 10 seconds Spool mail messages for delivery to: Disk Apparently this version of CF can handle millions of emails, so i'm assuming there is some settings that might need to be changed. Any suggestions much appreciated! Code: --------------------------------------------------- <cfsetting requesttimeout="500"> <cfoutput query="rs_news"> <cftry> <cfmail from="[EMAIL PROTECTED]" to="#rs_news.email#" subject="Testmail" type="HTML"> #text_content# </cfmail> <cfcatch type="any"></cfcatch> </cftry> </cfoutput> --------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193514 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
