Hey Daniel, In order to assist you, it would be helpful to see the code that has the loop as well as some knowledge of what the 'database call' is doing. (maybe the database call isn't returning?)
The cfsetting that you mention, does only change the timeout setting for the page that it is set in. It does not change the master settings in the cfadmin, so it will not effect other pages on your website directly. (this is true from CF7 thru CF9, and I would expect any future version of CF as well) The issue that it appears that you are running into is two-fold. 1. how many 'actions' are you looping over combined with 2. how long does it take to complete each action. Setting up a 'grouped' plan to only run x of them is a valid assessment, but I would suggest that you do this by tracking which ones need to be redone outside of the page. An example would be, you could have each of the necessary redone's to show up in a database table, and mark them as completed once they are done. The you would just need to pull the oldest 5 of them each time you load the page. (this would mean the page would have to be loaded more often. The best solution for you, will probably come after you have posted some more information (the loop code and 'what' the action is doing) hope this helps, William ---------- William E. Seiter On Jun 27, 2011, daniel kessler <dani...@umd.edu> wrote: I'm creating a scheduled_task to correct a problem. For the correction, I'm doing a query for the list of problem records. Then I'm looping through the problem records and resending each one of them through the same code that it went through when it developed the problem. That code has several database updates. Unfortunately, I'm timing out of the cfloop. I don't have access to the page that I'm looping through, so I can't change it. Is there a way to let a loop have other transactions so that it doesn't time out? I thought of putting the loop in another loop, so that it only does 5 at a time, but then that's just a loop in a loop and then the outer one will time out. Did I state this clearly? A friend of mine suggested the line: cfsetting requestTimeOut = "120â I am told that this setting will only be persistent for that page and that the timeout will revert to it's previous setting once the page is done running. Is that correct? I was also concerned that when CF is upgraded (we're on CF7 for this app) that this setting might be trouble. Any thoughts? Overall, I'd like a different solution than this, something that will make the loop more acceptable. thank you for any assistance. daniel ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:345806 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
