Re: Dreamweaver CS6 FTP issues fixed?

2013-08-19 Thread george.e...@ssa.gov george.e...@ssa.gov
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 se

RE: Pausing a loop or query

2013-08-19 Thread Rick Faircloth
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 morn

RE: Pausing a loop or query

2013-08-19 Thread Rick Faircloth
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 morn

Re: Using IN() within a cfquery statement

2013-08-19 Thread Russ Michaels
coldfusiondocs.com not working properly either, so seems likely. On Mon, Aug 19, 2013 at 4:26 PM, Carl Von Stetten wrote: > > 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? >

Re: Using IN() within a cfquery statement

2013-08-19 Thread Carl Von Stetten
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

RE: Pausing a loop or query

2013-08-19 Thread Rick Sanders
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 hack

Re: Pausing a loop or query

2013-08-19 Thread Raymond Camden
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.

Re: Pausing a loop or query

2013-08-19 Thread Dave Watts
> 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

Pausing a loop or query

2013-08-19 Thread Rick Sanders
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 p

Re: Using IN() within a cfquery statement

2013-08-19 Thread Dave Watts
> 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 declini

Re: Using IN() within a cfquery statement

2013-08-19 Thread Russ Michaels
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 mi

RE: Using IN() within a cfquery statement

2013-08-19 Thread DURETTE, STEVEN J
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

Re: Using IN() within a cfquery statement

2013-08-19 Thread Matt Quackenbush
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 an

Re: Using IN() within a cfquery statement

2013-08-19 Thread Raymond Camden
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 wrote: > > > Dave... I'm surprised. Wouldn't you think that CFQueryParam would be the > better way? > > > > Where stuff in ( cfsqltype="appropriate typ

Re: Using IN() within a cfquery statement

2013-08-19 Thread Dave Watts
> Dave... I'm surprised. Wouldn't you think that CFQueryParam would be the > better way? > > Where stuff in () 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.co

RE: Using IN() within a cfquery statement

2013-08-19 Thread Mark A Kruger
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

RE: Using IN() within a cfquery statement

2013-08-19 Thread DURETTE, STEVEN J
Dave... I'm surprised. Wouldn't you think that CFQueryParam would be the better way? Where stuff in () 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

Re: Using IN() within a cfquery statement

2013-08-19 Thread Dave Watts
> 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 ar

Using IN() within a cfquery statement

2013-08-19 Thread te...@it-werks.com te...@it-werks.com
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 ~