The flat file 15M emails were first imported into SQL assigning unique id =
1 to 15m.
A schedule was setup in CF Administrator to run a URL every 20 minutes
starting at noon and finishing at 0800 the following day. Here is the code
that would go at the top of the cfm file:
<cfparam name="url.start" default="1000000">
<cfset sendThisMany = 100000>
<cfset endHere = start + sendThisMany>
<cfquery name="email" datasource="Name" username="*********"
password="******" dbtype="ODBC">
select Email from Email_table
where id > #url.start# and id < #endHere#
</cfquery>
No loops here ... unless it is built in to CFML.
Here is an example of the cfx:
<cfx_imsmail
query="email"
queryfield="email"
qtoken_ID="ID"
qtoken_Name="Name"
header_from=" ""DGo Pro "" <[EMAIL PROTECTED]>"
header_to="<:smtpto:>"
header_Reply_To=" ""DGo Pro "" <[EMAIL PROTECTED]>"
parsetokens="yes"
header_subject="Subject"
smtpfrom="[EMAIL PROTECTED]"
failto="[EMAIL PROTECTED]"
Body="This is the text only part......"
html="">
In the html above code is used for tracking opens, clicks, etc.
Do you want to know what that html looks like?
Regards,
DGo
-----Original Message-----
From: John Wright [mailto:[EMAIL PROTECTED]
Sent: Friday, April 02, 2004 12:11 PM
To: inFusion Support List
Subject: Re: [iMS] RAMDisk results
David,
I am confused by some of your responses:
- You say not to use loops, but then you mention passing in a unique id to
the CFX tag.
- You say the process that involved the unique id was done on "another
subnet" but then you say the CFX tag and POST module are on the same server.
What do you mean by another subnet? Is there more than one server involved?
- 500,000 for MX cache sounds really high. I don't think I have ever seen
Howie recommend above 5,000.
Thanks again.
John
==^=======================================================
This list server is Powered by iMS "The Swiss Army Knife of Mail Servers"
--------------------------------------------------------------------------------------
This list is provided as a free service. Although we will try to address issues
in a timely manner, support via this list is not guaranteed. If you require expedited
support then a support contract is required. Support may be purchased from
http://www.coolfusion.com/commerce. Details regarding support options may be reviewed
at: http://www.coolfusion.com/SupportOptions.cfm
--------------------------------------------------------------------------------------
To leave this list please complete the form at http://www.coolfusion.com/Support/
Need an iMS Developer license? Sign up for a free license here:
http://www.coolfusion.com/Developers/
List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
Note: You are subscribed as [EMAIL PROTECTED]
==^=======================================================
