Using IN() within a cfquery statement
I have a select name=stuff multiple in a form filled with results from a query. I get the form field value: stuff=selection1,selection5,selection12. How do I then build a cfquery using the stuff variable in the IN() statement? Terry ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356483 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Using IN() within a cfquery statement
I have a select name=stuff multiple in a form filled with results from a query. I get the form field value: stuff=selection1,selection5,selection12. How do I then build a cfquery using the stuff variable in the IN() statement? Use the quotedValueList function to wrap single quotes around them. SELECT ... FROM ... WHERE STUFF IN (#quotedValueList(form.stuff)#) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356484 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Using IN() within a cfquery statement
Dave... I'm surprised. Wouldn't you think that CFQueryParam would be the better way? Where stuff in (cfqueryparam value=#form.stuff# cfsqltype=appropriate type list=yes separator=, /) Steve -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, August 19, 2013 9:42 AM To: cf-talk Subject: Re: Using IN() within a cfquery statement I have a select name=stuff multiple in a form filled with results from a query. I get the form field value: stuff=selection1,selection5,selection12. How do I then build a cfquery using the stuff variable in the IN() statement? Use the quotedValueList function to wrap single quotes around them. SELECT ... FROM ... WHERE STUFF IN (#quotedValueList(form.stuff)#) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356485 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Using IN() within a cfquery statement
Dave is allowed one weak answer per year... he's waited til August so I say we give him a break :) -Mark -Original Message- From: DURETTE, STEVEN J [mailto:sd1...@att.com] Sent: Monday, August 19, 2013 8:46 AM To: cf-talk Subject: RE: Using IN() within a cfquery statement Dave... I'm surprised. Wouldn't you think that CFQueryParam would be the better way? Where stuff in (cfqueryparam value=#form.stuff# cfsqltype=appropriate type list=yes separator=, /) Steve -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, August 19, 2013 9:42 AM To: cf-talk Subject: Re: Using IN() within a cfquery statement I have a select name=stuff multiple in a form filled with results from a query. I get the form field value: stuff=selection1,selection5,selection12. How do I then build a cfquery using the stuff variable in the IN() statement? Use the quotedValueList function to wrap single quotes around them. SELECT ... FROM ... WHERE STUFF IN (#quotedValueList(form.stuff)#) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356486 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Using IN() within a cfquery statement
Dave... I'm surprised. Wouldn't you think that CFQueryParam would be the better way? Where stuff in (cfqueryparam value=#form.stuff# cfsqltype=appropriate type list=yes separator=, /) Yes, that would absolutely be a better way, of course! I didn't even pay attention to the fact that this was in the form scope. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356487 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Using IN() within a cfquery statement
I'm going to go print this email out right now. For the next time Dave is wrong. Sometime in 2019. On Mon, Aug 19, 2013 at 8:53 AM, Dave Watts dwa...@figleaf.com wrote: Dave... I'm surprised. Wouldn't you think that CFQueryParam would be the better way? Where stuff in (cfqueryparam value=#form.stuff# cfsqltype=appropriate type list=yes separator=, /) Yes, that would absolutely be a better way, of course! I didn't even pay attention to the fact that this was in the form scope. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356489 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Using IN() within a cfquery statement
I take an entirely different viewpoint on Dave's answer. I read the original post and declined to answer because it seemed pretty obvious that ZERO effort was put in place by the questioner to find an answer. My bet is Dave had a similar feeling regarding the effort, but instead of declining to answer gave the quickest and easiest answer that could/would be found by a quick search or perusal of the documentation. Sometimes RTFM *is* the appropriate response. ;-) On Mon, Aug 19, 2013 at 9:50 AM, Mark A Kruger mkru...@cfwebtools.comwrote: Dave is allowed one weak answer per year... he's waited til August so I say we give him a break :) -Mark -Original Message- From: DURETTE, STEVEN J [mailto:sd1...@att.com] Sent: Monday, August 19, 2013 8:46 AM To: cf-talk Subject: RE: Using IN() within a cfquery statement Dave... I'm surprised. Wouldn't you think that CFQueryParam would be the better way? Where stuff in (cfqueryparam value=#form.stuff# cfsqltype=appropriate type list=yes separator=, /) Steve -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, August 19, 2013 9:42 AM To: cf-talk Subject: Re: Using IN() within a cfquery statement I have a select name=stuff multiple in a form filled with results from a query. I get the form field value: stuff=selection1,selection5,selection12. How do I then build a cfquery using the stuff variable in the IN() statement? Use the quotedValueList function to wrap single quotes around them. SELECT ... FROM ... WHERE STUFF IN (#quotedValueList(form.stuff)#) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356488 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Using IN() within a cfquery statement
Matt, I was just teasing Dave. I actually have a lot of respect for Dave for all the information he gives and his ability to put it in a security context. In regards to your response about the quickest answer because someone didn't RTFM and coming from a security background, I always believe that it is better to give a security focused answer if possible because for too long security hasn't even been a consideration in programming even though it should be one of the first things taught. Also, we also need to consider that RTFM might not be a totally viable option in some situations. I know from trying to look something up last week that I couldn't get to cfquickdocs and cfgloss took over 15 minutes to load before I could search. This also could be a situation where the original poster has access to email but their web browsers are restricted to internal sites only. Not trying to start a fight, just giving another perspective. We've all been there, super short deadline and the mind goes blank. Have a great day! Steve -Original Message- From: Matt Quackenbush [mailto:quackfu...@gmail.com] Sent: Monday, August 19, 2013 10:05 AM To: cf-talk Subject: Re: Using IN() within a cfquery statement I take an entirely different viewpoint on Dave's answer. I read the original post and declined to answer because it seemed pretty obvious that ZERO effort was put in place by the questioner to find an answer. My bet is Dave had a similar feeling regarding the effort, but instead of declining to answer gave the quickest and easiest answer that could/would be found by a quick search or perusal of the documentation. Sometimes RTFM *is* the appropriate response. ;-) On Mon, Aug 19, 2013 at 9:50 AM, Mark A Kruger mkru...@cfwebtools.comwrote: Dave is allowed one weak answer per year... he's waited til August so I say we give him a break :) -Mark -Original Message- From: DURETTE, STEVEN J [mailto:sd1...@att.com] Sent: Monday, August 19, 2013 8:46 AM To: cf-talk Subject: RE: Using IN() within a cfquery statement Dave... I'm surprised. Wouldn't you think that CFQueryParam would be the better way? Where stuff in (cfqueryparam value=#form.stuff# cfsqltype=appropriate type list=yes separator=, /) Steve -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, August 19, 2013 9:42 AM To: cf-talk Subject: Re: Using IN() within a cfquery statement I have a select name=stuff multiple in a form filled with results from a query. I get the form field value: stuff=selection1,selection5,selection12. How do I then build a cfquery using the stuff variable in the IN() statement? Use the quotedValueList function to wrap single quotes around them. SELECT ... FROM ... WHERE STUFF IN (#quotedValueList(form.stuff)#) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356490 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Using IN() within a cfquery statement
While people are sometimes lazy, it is not fair to just jump to that conclusion, and it is that negative attitude that has driven so many people to leave this list. It is all well and good to say RTFM, but if you are a newbie and do not know what you are looking for, you could easily completely miss quotedValueList() On Mon, Aug 19, 2013 at 3:04 PM, Matt Quackenbush quackfu...@gmail.comwrote: I take an entirely different viewpoint on Dave's answer. I read the original post and declined to answer because it seemed pretty obvious that ZERO effort was put in place by the questioner to find an answer. My bet is Dave had a similar feeling regarding the effort, but instead of declining to answer gave the quickest and easiest answer that could/would be found by a quick search or perusal of the documentation. Sometimes RTFM *is* the appropriate response. ;-) On Mon, Aug 19, 2013 at 9:50 AM, Mark A Kruger mkru...@cfwebtools.com wrote: Dave is allowed one weak answer per year... he's waited til August so I say we give him a break :) -Mark -Original Message- From: DURETTE, STEVEN J [mailto:sd1...@att.com] Sent: Monday, August 19, 2013 8:46 AM To: cf-talk Subject: RE: Using IN() within a cfquery statement Dave... I'm surprised. Wouldn't you think that CFQueryParam would be the better way? Where stuff in (cfqueryparam value=#form.stuff# cfsqltype=appropriate type list=yes separator=, /) Steve -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, August 19, 2013 9:42 AM To: cf-talk Subject: Re: Using IN() within a cfquery statement I have a select name=stuff multiple in a form filled with results from a query. I get the form field value: stuff=selection1,selection5,selection12. How do I then build a cfquery using the stuff variable in the IN() statement? Use the quotedValueList function to wrap single quotes around them. SELECT ... FROM ... WHERE STUFF IN (#quotedValueList(form.stuff)#) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356491 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Using IN() within a cfquery statement
I take an entirely different viewpoint on Dave's answer. I read the original post and declined to answer because it seemed pretty obvious that ZERO effort was put in place by the questioner to find an answer. My bet is Dave had a similar feeling regarding the effort, but instead of declining to answer gave the quickest and easiest answer that could/would be found by a quick search or perusal of the documentation. No, not really. I just have a weak spot for valueList and quotedValueList. There's a long and not very interesting story behind that that I won't bother going into here. Had I put more thought into my response, I'd have followed Steven's advice. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356492 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Pausing a loop or query
Here's the situation. A client of mine has an email list he sends a flyer to once a month to about 5000 addresses. I need to pause after sending 250 so the server doesn't get flagged for spamming. What's the best way to do this? It's easy to do multiple queries of 250 rows each, but how can I pause for say 5 or 10mins in between? Kind Regards, Rick Sanders T: 902-401-7689 W: www.webenergy.cahttp://www.webenergy.ca/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356493 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Pausing a loop or query
Here's the situation. A client of mine has an email list he sends a flyer to once a month to about 5000 addresses. I need to pause after sending 250 so the server doesn't get flagged for spamming. What's the best way to do this? It's easy to do multiple queries of 250 rows each, but how can I pause for say 5 or 10mins in between? You can use CFSCHEDULE to do this sort of thing. Write a page that schedules another page (or the same page with different URL parameters, etc) to run at n minutes in the future. You could have the initial page execution figure out how many records there are altogether, divide that accordingly, then schedule several page executions across the appropriate amount of time. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356494 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Pausing a loop or query
Kinda hacky, but: Use a db table/column for misc crap, or hell, even a server variable, and save something called: lastRow, 1 Do a SQL to get 250 addresses starting at row lastRow. Process your mail. When done, set lastRow to lastRow + 250. All of the above would be a CFM hit via cfschedule. On Mon, Aug 19, 2013 at 9:55 AM, Rick Sanders r...@webenergy.ca wrote: Here's the situation. A client of mine has an email list he sends a flyer to once a month to about 5000 addresses. I need to pause after sending 250 so the server doesn't get flagged for spamming. What's the best way to do this? It's easy to do multiple queries of 250 rows each, but how can I pause for say 5 or 10mins in between? Kind Regards, Rick Sanders T: 902-401-7689 W: www.webenergy.cahttp://www.webenergy.ca/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356495 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Pausing a loop or query
OK thanks guys. So similar to doing a cron job. Kind Regards, Rick Sanders T: 902-401-7689 W: www.webenergy.ca -Original Message- From: Raymond Camden [mailto:raymondcam...@gmail.com] Sent: Monday, August 19, 2013 12:13 PM To: cf-talk Subject: Re: Pausing a loop or query Kinda hacky, but: Use a db table/column for misc crap, or hell, even a server variable, and save something called: lastRow, 1 Do a SQL to get 250 addresses starting at row lastRow. Process your mail. When done, set lastRow to lastRow + 250. All of the above would be a CFM hit via cfschedule. On Mon, Aug 19, 2013 at 9:55 AM, Rick Sanders r...@webenergy.ca wrote: Here's the situation. A client of mine has an email list he sends a flyer to once a month to about 5000 addresses. I need to pause after sending 250 so the server doesn't get flagged for spamming. What's the best way to do this? It's easy to do multiple queries of 250 rows each, but how can I pause for say 5 or 10mins in between? Kind Regards, Rick Sanders T: 902-401-7689 W: www.webenergy.cahttp://www.webenergy.ca/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356496 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Using IN() within a cfquery statement
I wonder if the problems with cfquickdocs and cfgloss are related to the switchover of the ColdFusion docs to the new wiki format? Or is that only for CF10 docs? -Carl V. On 8/19/2013 7:15 AM, DURETTE, STEVEN J wrote: I know from trying to look something up last week that I couldn't get to cfquickdocs and cfgloss took over 15 minutes to load before I could search. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356497 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Using IN() within a cfquery statement
coldfusiondocs.com not working properly either, so seems likely. On Mon, Aug 19, 2013 at 4:26 PM, Carl Von Stetten vonner.li...@vonner.netwrote: I wonder if the problems with cfquickdocs and cfgloss are related to the switchover of the ColdFusion docs to the new wiki format? Or is that only for CF10 docs? -Carl V. On 8/19/2013 7:15 AM, DURETTE, STEVEN J wrote: I know from trying to look something up last week that I couldn't get to cfquickdocs and cfgloss took over 15 minutes to load before I could search. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356498 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Pausing a loop or query
How about using a scheduled task to run a series of mail sends
of 250 each, the as part of the task, schedules another task
5-10 minutes later to send another task. Repeat as needed.
Here's what part of a scheduled task would look like that I used
to process a Real Estate data download every morning:
cfthread action=run name=schedule_01i_hilly_peterson_concierge_processing
!--- [ set up the delay routine ] ---
cfset cfthread.sleepTime = 0
cfset cfthread.initialized = false
!--- [ the cfloop continues to loop until the status of the previous
cfthred, in that case named email_results is completed
or terminated (due to a failure) ] ---
cfloop condition=cfthread.email_results.status neq 'completed' and
cfthread.email_results.status neq 'terminated'
cfset sleep(1) /
cfset cfthread.sleeptime++ /
/cfloop
cfschedule action = update
task = vds_01i_hilly_peterson_concierge_processing
operation = HTTPRequest
url=
http://localhost/scheduledTasks/vds/01i_hilly_peterson_concierge_processing_vds;
startdate = #DateFormat(Now(), 'm/d/')#
starttime = #TimeFormat(DateAdd('n', 2, now()), 'h:mm
tt')#
interval = once
!--- [ the following cfmail is just to notify me that the task has run
and has set up the next task ] ---
cfmail to = r...@whitestonemedia.com
from =
conciergepropertyprocess...@whitestonemedia.com
subject= vds_01i_hilly_peterson_concierge_processing
has been scheduled.
Schedule Task,
whitestone_01i_hilly_peterson_concierge_processing,
will run in 2 minutes.
/cfmail
/cfthread
Rick
-Original Message-
From: Rick Sanders [mailto:r...@webenergy.ca]
Sent: Monday, August 19, 2013 10:55 AM
To: cf-talk
Subject: Pausing a loop or query
Here's the situation. A client of mine has an email list he sends a flyer to
once a month to about 5000
addresses. I need to pause after sending 250 so the server doesn't get flagged
for spamming. What's the best
way to do this?
It's easy to do multiple queries of 250 rows each, but how can I pause for say
5 or 10mins in between?
Kind Regards,
Rick Sanders
T: 902-401-7689
W: www.webenergy.cahttp://www.webenergy.ca/
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356500
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Pausing a loop or query
How about using a scheduled task to run a series of mail sends
of 250 each, the as part of the task, schedules another task
5-10 minutes later to send another task. Repeat as needed.
Here's what part of a scheduled task would look like that I used
to process a Real Estate data download every morning:
cfthread action=run name=schedule_01i_hilly_peterson_concierge_processing
!--- [ set up the delay routine ] ---
cfset cfthread.sleepTime = 0
cfset cfthread.initialized = false
!--- [ the cfloop continues to loop until the status of the previous
cfthred, in that case named email_results is completed
or terminated (due to a failure) ] ---
cfloop condition=cfthread.email_results.status neq 'completed' and
cfthread.email_results.status neq 'terminated'
cfset sleep(1) /
cfset cfthread.sleeptime++ /
/cfloop
cfschedule action = update
task = vds_01i_hilly_peterson_concierge_processing
operation = HTTPRequest
url=
http://localhost/scheduledTasks/vds/01i_hilly_peterson_concierge_processing_vds;
startdate = #DateFormat(Now(), 'm/d/')#
starttime = #TimeFormat(DateAdd('n', 2, now()), 'h:mm
tt')#
interval = once
!--- [ the following cfmail is just to notify me that the task has run
and has set up the next task ] ---
cfmail to = r...@whitestonemedia.com
from =
conciergepropertyprocess...@whitestonemedia.com
subject= vds_01i_hilly_peterson_concierge_processing
has been scheduled.
Schedule Task,
whitestone_01i_hilly_peterson_concierge_processing,
will run in 2 minutes.
/cfmail
/cfthread
Rick
-Original Message-
From: Rick Sanders [mailto:r...@webenergy.ca]
Sent: Monday, August 19, 2013 10:55 AM
To: cf-talk
Subject: Pausing a loop or query
Here's the situation. A client of mine has an email list he sends a flyer to
once a month to about 5000
addresses. I need to pause after sending 250 so the server doesn't get flagged
for spamming. What's the best
way to do this?
It's easy to do multiple queries of 250 rows each, but how can I pause for say
5 or 10mins in between?
Kind Regards,
Rick Sanders
T: 902-401-7689
W: www.webenergy.cahttp://www.webenergy.ca/
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356499
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Dreamweaver CS6 FTP issues fixed?
Hi Brian, Sorry for the delay in responding. First my message(s) didn't get posted until days after I sent them, then I was out of town last week . . . I was referring to a number of assorted issues with FTP in DW CS6 including connecting to remote servers, maintaing connections with remote servers, permissions on uploaded files changing when they arrive at the remote server, etc. Lots of folks reverted back to DW CS5.5 or earlier. George Hey George, Are you referring to the line spacing issue on a Mac that occurs when using a windows based FTP server? I ran into that issue and adobe was no help either however I found a solution and can share the info if that's the problem your asking about? Thanks, Brian Sent from my mobile device, please excuse brevity spelling. On Aug 9, 2013, at 10:05 AM, george.e...@ssa.gov george.e...@ssa.gov george.e...@ssa.gov wrote: Do you use Dreamweaver CS6 to write your markup\code? Do you use the FTP built into DW CS6? Has Adobe fixed all the issues folks were having with FTP in DW CS6? (I posted this question to the DW forum at Adobe and got one response that told me to use a third party standalone FTP client which is a valid suggestion but doesn't answer my question - at least not directly.) Thanks! George ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356501 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ColdFusion Developer -GermanTown,MD
6+ Month Contact position Requirement/ Experience Bachelors Degree 6-8 years overall business experience. 4-5 years of recent Cold Fusion experience. Designing, developing, and maintaining Internet site content and applications using Web development tools Macromedia's Dreamweaver or other ColdFusion-specific editing tools and ColdFusion Working in a multi-server environment (MS Windows) using development, testing, staging and production servers. HTML,JavaScript, and CSS. Cold Fusion server 8, 9 and 10. Git and GitHub. FTP, VPN, and terminal services clients. MS SQL Server 2005 or higher AND Oracle 10g or higher If interested in applying or getting further details, please email your resume to jaime.mavi...@nerjobs.com OR call Jaime Mavilia @ 877-871-0785 ext. 117 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4608 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-jobs-talk/unsubscribe.cfm
