Sean,
Thanks for the reply - definately looks a good idea, and thanks for the code
example. I'll ask my ISP if they'll install the tag, and give it a try.
Out of interest, with what sized query have you tried this with?
Will
--
[EMAIL PROTECTED] -=- www.lukrative.com
Local-Advertising -=- www.localbounty.com
> If you try to send out a ton of mail at once with CFMAIL, for some reason
it
> just stops working and you have to reboot the server or reinstall the dll.
> Allaire just hasn't quite got thier arms around CFMAIL and CFFTP yet. And
> they especially didn't have thier arms around it in 4.0. What I found
works
> is putting CFMAIL inside a loop and foregoing the query attribute. Then
use
> the cfx_wait tag between each iteration of the loop. BTW, Tony Aly came up
> with this solution, so I cannot take credit for it. It works, give it a
> try.
>
> EG.,
> <cfloop query="get_email_addresses">
> <cftry>
> <cfmail to="#trim(current_email)#"
> from="#trim(get_email_message.from_vc)#"
> subject="#trim(get_email_message.subject_vc)#"
> server="#trim(attributes.mail_server)#">#get_email_message.message_mem#
> </cfmail>
> <CFX_Wait Sleeptime="1">
> <cfcatch>
> <CFX_Wait Sleeptime="10">
> </cfcatch>
> </cftry>
> </cfloop>
>
> The CFX_WAIT tag is available in the Allaire tag library
>
> ----- Original Message -----
> From: "W Luke" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Sunday, March 04, 2001 12:06 PM
> Subject: Mailing Shots in CF
>
>
> > Hi,
> >
> > I'm looking for a bit of advice and ideas with Mailing Shots in CF. I
run
> a
> > site with an Access DB, and use a basic <cfmail> query to grab the
members
> > and send the weekly mail out - however only half the members receive the
> > email, due to a timeout problem. I don't know why - default 30
> > second-timeout seems huge enough to me, and the query is relatively
small
> > (500 or so members).
> >
> > So, my questions are:
> >
> > 1) Why am I getting a timeout?
> > 2) How can I send out a mail-shot to my customers?
> > 3) I asked my ISP to install CoolFusion's IMS...but they didn't want to
:(
> >
> > Thanks for any tips or general ideas on this.
> >
> > Will
> > [EMAIL PROTECTED] -=- www.lukrative.com
> > Local-Advertising -=- www.localbounty.com
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
