I have to do the loop because the email files contain dynamic content which
needs to be executed for each recipient. Basically just a series of <cfif>
statements which include content matching a users preferences.
The actual preference flags are user defined and the <cfif> statements are
also dynamically generated. The cfml is written to a file which contains
the email body and all of the dynamic content between the <cfif> statements.
The only way I could figure out to execute the dynamically generated
content was by writing it to a temp file and then including it to create
the body. Can you think of a better way to do this?
When there is no dynamic content, then I use the Qtokens.
Brook
At 05:26 PM 26/07/02 -0400, you wrote:
>----- Original Message -----
>From: "Brook Davies" <[EMAIL PROTECTED]>
>To: "inFusion Support List" <[EMAIL PROTECTED]>
>Sent: Friday, July 26, 2002 5:37 PM
>Subject: [iMS] recording recipients on send
>
>
> > Hello,
> >
> > Lets say I have 25,000 recipients returned from a query and I start to loop
> > over the cfx_imsmail tag. Does it make sense to build a new query and add
> > each recipient one by one to this new query object?
> >
> > Then, after the loop I can use this query to write the to the database the
> > complete list of recipients.
> >
>
>The cfx tag can take all the recipients from the query - no need to loop
>over the tag (use query and queryfield
>parameters).
>
> > I could wrap this in a cftry/catch block, where the catch block records the
> > successful deliveries (from the query I was building row by row) and then
> > reschedules the rest or something like that.
> >
> > Does this make sense as a way to track which recipients had actually been
> > sent to the que? Is this going to create to much additional overhead?
> >
>
>The cfx tag will throw an exception if there is a problem writing to the
>queue. So, you can trap on that. In all the
>years we've been using the cfx and supporting others that use it I have
>only seen or heard of write errors when the
>queue disk is full.
>
> > Also, I am calling the imsmail tag within a query output like this:
> >
> > <cfoutput query="rcp">
> > <cfsavecontent variable="emailbody">
> > <cfinclude template="dynamicallygeneratedemailbody.cfm">
> > </cfsavecontent>
> >
> > <!--- send mail to single recipient using the emailbody built above --->
> > <cinclude template="act_sendmail.cfm">
> > </cfoutput>
> >
> > Am I asking for trouble on large(25,000-50,000) mailing campaigns like
> this?
> >
>
>The differences between using one call of the cfx and looping over it are
>that the looping is slower and the looping
>will utilize more space on the disk and a bigger overall queue.
>
>Regards,
>
>Howie
>
>
> > Brook Davies
> >
> >
> >
> >
==^=======================================================
This list server is Powered by iMS
"The Swiss Army Knife of Mail Servers"
--------------------------------------
To leave this list please complete the form at
http://www.coolfusion.com/iMSSupport.cfm
Need an iMS Developer license? Sign up for a free license here:
http://www.coolfusion.com/iMSDevelopers.cfm
List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
Note: You are subscribed as [email protected]
==^=======================================================
