Re: [ACFUG Discuss] Sending large numbers of eMail via ColdFusion

[Douglas Knudsen]

I've just used a scheduled task with the long running template override set
on it.   Had one running over a hour before that was moshing out 20k emails
at night without a hiccup, no pauses in processing at all.  Took so long
because each email required a particular long SQL query to execute, darn
complex sales data.  Didn't have CFTHREAD then or would have knocked it to
the threaded curb for sure.


Douglas Knudsen
http://www.cubicleman.com
this is my signature, like it?


On Thu, May 21, 2009 at 5:30 PM, Dawn Hoagland wrote:

> I've successfully used a meta-refresh with a counter keeping track of which
> batch of emails have been sent (via session or url parameter) for a quick
> and dirty way to throttle mass emails.
>
> Dawn
>
>
> On Thu, May 21, 2009 at 5:24 PM, Troy Jones  wrote:
>
>>  Clarke,
>>
>>
>>
>> We have a similar application that sends out mass mailings. In the past we
>> have handled this using cfthread. In this simplified example, the code is
>> using cfthread to set a 1 second interval between each email.
>>
>>
>>
>> 
>>
>> 
>>
>>
>> > IsEmail(email_field)>
>>
>> > valid_email>
>>
>>
>>
>>
>> 
>>
>>
>>
>>
>> 
>>
>> 
>>
>> > duration="1000" />
>>
>> 
>>
>> 
>>
>>
>>
>> This seems to work pretty well although you may want to adjust the
>> interval (remember, in milliseconds). It has two purposes. First, it takes
>> the processing out of the way of the rest of your other processing.
>> Secondly, and maybe just as important, it will help prevent your mail server
>> from getting tagged as a spam source.
>>
>>
>>
>> Hope this helps.
>>
>>
>>
>> *Troy Jones*
>>
>> Developer/Support Technician
>>
>> Dynapp, Inc
>>
>> http://www.dynapp.com
>>
>>
>>
>> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Clarke
>> Bishop
>> *Sent:* Thursday, May 21, 2009 4:59 PM
>> *To:* discussion@acfug.org
>> *Subject:* [ACFUG Discuss] Sending large numbers of eMail via ColdFusion
>>
>>
>>
>> I’m trying to finish up a cfm/cfc page that will send out about 3,000
>> eMail messages. The messages are press releases and they go to a database of
>> magazine editors, radio/TV stations, etc. Also, the messages have to be
>> individually personalized.
>>
>>
>>
>> John told me: “Don't try to send 3000 all at once. You'll lock up your
>> mail spool.  Do small 50-120 size batches every 10 minutes.”
>>
>>
>>
>> Plus, I got a timeout error when I tried to run the page.
>>
>>
>>
>> So, please point me in the right direction. Right now, I’m thinking:
>>
>> · Use cfschedule to call a page every 10 minutes. The page then
>> sends 100 messages.
>>
>> · Keep track of which emails have been sent and which page of the
>> query should get sent next.
>>
>> · Cancel the cfschedule after all the messages are done.
>>
>>
>>
>> Does anyone have a better suggestion for how to go about this?
>>
>>
>>
>> Thanks,
>>
>>
>>
>>Clarke
>>
>>
>> -
>> To unsubscribe from this list, manage your profile @
>> http://www.acfug.org?fa=login.edituserform
>>
>> For more info, see http://www.acfug.org/mailinglists
>> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
>> List hosted by FusionLink 
>> -
>>
>> No virus found in this incoming message.
>> Checked by AVG - www.avg.com
>> Version: 8.5.339 / Virus Database: 270.12.35/2124 - Release Date: 05/21/09
>> 06:22:00
>>
>> -
>> To unsubscribe from this list, manage your profile @
>> http://www.acfug.org?fa=login.edituserform
>>
>> For more info, see http://www.acfug.org/mailinglists
>> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
>> List hosted by FusionLink 
>> -
>>
>
>

Re: [ACFUG Discuss] Sending large numbers of eMail via ColdFusion

[Dawn Hoagland]

I've successfully used a meta-refresh with a counter keeping track of which
batch of emails have been sent (via session or url parameter) for a quick
and dirty way to throttle mass emails.

Dawn

On Thu, May 21, 2009 at 5:24 PM, Troy Jones  wrote:

>  Clarke,
>
>
>
> We have a similar application that sends out mass mailings. In the past we
> have handled this using cfthread. In this simplified example, the code is
> using cfthread to set a 1 second interval between each email.
>
>
>
> 
>
> 
>
>  IsEmail(email_field)>
>
>  valid_email>
>
>
>
>
> 
>
>
>
>
> 
>
> 
>
>  duration="1000" />
>
> 
>
> 
>
>
>
> This seems to work pretty well although you may want to adjust the interval
> (remember, in milliseconds). It has two purposes. First, it takes the
> processing out of the way of the rest of your other processing. Secondly,
> and maybe just as important, it will help prevent your mail server from
> getting tagged as a spam source.
>
>
>
> Hope this helps.
>
>
>
> *Troy Jones*
>
> Developer/Support Technician
>
> Dynapp, Inc
>
> http://www.dynapp.com
>
>
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Clarke
> Bishop
> *Sent:* Thursday, May 21, 2009 4:59 PM
> *To:* discussion@acfug.org
> *Subject:* [ACFUG Discuss] Sending large numbers of eMail via ColdFusion
>
>
>
> I’m trying to finish up a cfm/cfc page that will send out about 3,000 eMail
> messages. The messages are press releases and they go to a database of
> magazine editors, radio/TV stations, etc. Also, the messages have to be
> individually personalized.
>
>
>
> John told me: “Don't try to send 3000 all at once. You'll lock up your mail
> spool.  Do small 50-120 size batches every 10 minutes.”
>
>
>
> Plus, I got a timeout error when I tried to run the page.
>
>
>
> So, please point me in the right direction. Right now, I’m thinking:
>
> · Use cfschedule to call a page every 10 minutes. The page then
> sends 100 messages.
>
> · Keep track of which emails have been sent and which page of the
> query should get sent next.
>
> · Cancel the cfschedule after all the messages are done.
>
>
>
> Does anyone have a better suggestion for how to go about this?
>
>
>
> Thanks,
>
>
>
>Clarke
>
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> -
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.5.339 / Virus Database: 270.12.35/2124 - Release Date: 05/21/09
> 06:22:00
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink 
> -
>

RE: [ACFUG Discuss] Sending large numbers of eMail via ColdFusion

[Troy Jones]

Clarke,

 

We have a similar application that sends out mass mailings. In the past
we have handled this using cfthread. In this simplified example, the
code is using cfthread to set a 1 second interval between each email.

 











 




 












 

This seems to work pretty well although you may want to adjust the
interval (remember, in milliseconds). It has two purposes. First, it
takes the processing out of the way of the rest of your other
processing. Secondly, and maybe just as important, it will help prevent
your mail server from getting tagged as a spam source.

 

Hope this helps.

 

Troy Jones

Developer/Support Technician

Dynapp, Inc

http://www.dynapp.com

 

From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke
Bishop
Sent: Thursday, May 21, 2009 4:59 PM
To: discussion@acfug.org
Subject: [ACFUG Discuss] Sending large numbers of eMail via ColdFusion

 

I'm trying to finish up a cfm/cfc page that will send out about 3,000
eMail messages. The messages are press releases and they go to a
database of magazine editors, radio/TV stations, etc. Also, the messages
have to be individually personalized.

 

John told me: "Don't try to send 3000 all at once. You'll lock up your
mail spool.  Do small 50-120 size batches every 10 minutes."

 

Plus, I got a timeout error when I tried to run the page.

 

So, please point me in the right direction. Right now, I'm thinking:

* Use cfschedule to call a page every 10 minutes. The page then
sends 100 messages.

* Keep track of which emails have been sent and which page of
the query should get sent next.

* Cancel the cfschedule after all the messages are done.

 

Does anyone have a better suggestion for how to go about this?

 

Thanks,

 

   Clarke


- 
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform 

For more info, see http://www.acfug.org/mailinglists 
Archive @ http://www.mail-archive.com/discussion%40acfug.org/ 
List hosted by FusionLink   
- 

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.339 / Virus Database: 270.12.35/2124 - Release Date:
05/21/09 06:22:00




-

To unsubscribe from this list, manage your profile @ 

http://www.acfug.org?fa=login.edituserform



For more info, see http://www.acfug.org/mailinglists

Archive @ http://www.mail-archive.com/discussion%40acfug.org/

List hosted by http://www.fusionlink.com

-

[ACFUG Discuss] Sending large numbers of eMail via ColdFusion

[Clarke Bishop]

I'm trying to finish up a cfm/cfc page that will send out about 3,000 eMail
messages. The messages are press releases and they go to a database of
magazine editors, radio/TV stations, etc. Also, the messages have to be
individually personalized.

 

John told me: "Don't try to send 3000 all at once. You'll lock up your mail
spool.  Do small 50-120 size batches every 10 minutes."

 

Plus, I got a timeout error when I tried to run the page.

 

So, please point me in the right direction. Right now, I'm thinking:

. Use cfschedule to call a page every 10 minutes. The page then
sends 100 messages.

. Keep track of which emails have been sent and which page of the
query should get sent next.

. Cancel the cfschedule after all the messages are done.

 

Does anyone have a better suggestion for how to go about this?

 

Thanks,

 

   Clarke




-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-

Re: [ACFUG Discuss] Connecting to iSeries DB2

[Kevin Hellriegel]

I found an old article for 6.1 that had a few different configurations:

http://coldfusion.sys-con.com/node/42109

I went the JTOpen route since I'm on Standard and now I'm getting:
java.sql.SQLException: Timed out trying to establish connection

It's a step in the right direction. I'll have to get with our IBM guy
and find out what port I need to use, etc.

Thank you for all your help, guys!

Kevin

On Thu, May 21, 2009 at 3:03 PM, Cameron Childress  wrote:
> On Thu, May 21, 2009 at 2:55 PM, Kevin Hellriegel  wrote:
>> Does Standard come with the IBM DB2 UDB driver?
>
> Doesn't look like it:
>
> http://www.adobe.com/products/coldfusion/coldfusion7/editions/
>
> -Cameron
>
> --
> Cameron Childress
> Sumo Consulting Inc
> http://www.sumoc.com
> ---
> cell:  678.637.5072
> aim:   cameroncf
> email: camer...@gmail.com
>
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by http://www.fusionlink.com
> -
>
>
>
>


-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-

Re: [ACFUG Discuss] Connecting to iSeries DB2

[Cameron Childress]

On Thu, May 21, 2009 at 2:55 PM, Kevin Hellriegel  wrote:
> Does Standard come with the IBM DB2 UDB driver?

Doesn't look like it:

http://www.adobe.com/products/coldfusion/coldfusion7/editions/

-Cameron

-- 
Cameron Childress
Sumo Consulting Inc
http://www.sumoc.com
---
cell:  678.637.5072
aim:   cameroncf
email: camer...@gmail.com


-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-

Re: [ACFUG Discuss] Connecting to iSeries DB2

[Kevin Hellriegel]

Does Standard come with the IBM DB2 UDB driver?

On Thu, May 21, 2009 at 2:43 PM, Fennell, Mark P.  wrote:
> We are using the stock IBM DB2 UDB driver that shipped with MX7.
> It took a DB2 network specialist to figure it out, but under the Advanced 
> Settings in the connection string, we had to enter the locationName and 
> noprompt attributes like this "locationName=ARMC;noprompt=true" but without 
> the quotes and we connected to port 446. I think the locationName is the DB 
> name, kind of like master on SQL server or the SID in Oracle.
> Prior to figuring that out, we used the JTOpen jdbc driver.
> hth
> mf
>
> ps. this is on a FC7 x86 system running CFMX 7,0,0,91690 Enterprise.
>
>
> -Original Message-
> From: ad...@acfug.org [mailto:ad...@acfug.org]on Behalf Of Andrew Powell
> Sent: Thursday, May 21, 2009 2:32 PM
> To: discussion@acfug.org
> Subject: Re: [ACFUG Discuss] Connecting to iSeries DB2
>
>
> I believe there are third party JDBC drivers for this.
>
> ap
>
> On May 21, 2009, at 2:27 PM, Kevin Hellriegel wrote:
>
>> Does anyone have any experience connecting to a DB2 database on an
>> AS400 with ColdFusion MX 7? If I use the example on livedocs:
>>
>> http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/js/html/wwhelp.htm?href=1747.htm#1277913
>>
>> I get an error: java.sql.SQLException: No suitable driver
>>
>> I'm assuming I need a different connector or maybe I am leaving a
>> parameter out? Any help would be greatly appreciated.
>>
>> Kevin
>>
>>
>> -
>> To unsubscribe from this list, manage your profile @
>> http://www.acfug.org?fa=login.edituserform
>>
>> For more info, see http://www.acfug.org/mailinglists
>> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
>> List hosted by http://www.fusionlink.com
>> -
>>
>>
>>
>
>
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by http://www.fusionlink.com
> -
>
>
>
>
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?falogin.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by http://www.fusionlink.com
> -
>
>
>
>


-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-

RE: [ACFUG Discuss] Connecting to iSeries DB2

[Fennell, Mark P.]

We are using the stock IBM DB2 UDB driver that shipped with MX7.
It took a DB2 network specialist to figure it out, but under the Advanced 
Settings in the connection string, we had to enter the locationName and 
noprompt attributes like this "locationName=ARMC;noprompt=true" but without the 
quotes and we connected to port 446. I think the locationName is the DB name, 
kind of like master on SQL server or the SID in Oracle.
Prior to figuring that out, we used the JTOpen jdbc driver.
hth
mf

ps. this is on a FC7 x86 system running CFMX 7,0,0,91690 Enterprise.


-Original Message-
From: ad...@acfug.org [mailto:ad...@acfug.org]on Behalf Of Andrew Powell
Sent: Thursday, May 21, 2009 2:32 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] Connecting to iSeries DB2


I believe there are third party JDBC drivers for this.

ap

On May 21, 2009, at 2:27 PM, Kevin Hellriegel wrote:

> Does anyone have any experience connecting to a DB2 database on an
> AS400 with ColdFusion MX 7? If I use the example on livedocs:
>
> http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/js/html/wwhelp.htm?href=1747.htm#1277913
>
> I get an error: java.sql.SQLException: No suitable driver
>
> I'm assuming I need a different connector or maybe I am leaving a
> parameter out? Any help would be greatly appreciated.
>
> Kevin
>
>
> -
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by http://www.fusionlink.com
> -
>
>
>



-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-





-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-

Re: [ACFUG Discuss] Connecting to iSeries DB2

[Andrew Powell]

I believe there are third party JDBC drivers for this.

ap

On May 21, 2009, at 2:27 PM, Kevin Hellriegel wrote:


Does anyone have any experience connecting to a DB2 database on an
AS400 with ColdFusion MX 7? If I use the example on livedocs:

http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/js/html/wwhelp.htm?href=1747.htm#1277913

I get an error: java.sql.SQLException: No suitable driver

I'm assuming I need a different connector or maybe I am leaving a
parameter out? Any help would be greatly appreciated.

Kevin


-
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-







-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform


For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-

[ACFUG Discuss] Connecting to iSeries DB2

[Kevin Hellriegel]

Does anyone have any experience connecting to a DB2 database on an
AS400 with ColdFusion MX 7? If I use the example on livedocs:

http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/js/html/wwhelp.htm?href=1747.htm#1277913

I get an error: java.sql.SQLException: No suitable driver

I'm assuming I need a different connector or maybe I am leaving a
parameter out? Any help would be greatly appreciated.

Kevin


-
To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-