how would one do that if it was a long running query ? - I've got the same problem but I think it's sql that's causing the problem.
Cheers Richard ----- Original Message ----- From: "S. Isaac Dealey" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, June 09, 2003 3:20 PM Subject: Re: Mechanisms for stopping a running script > > I've been thinking about some ideas on how to stop running > > scripts, like > > an ABORT button. This is the first thought I came up with. > > Any other > > ideas? This comes up for me because I have several LONG > > running scripts > > that occassionally, I might want to stop w/o having to > > bounce the cf > > server to do so... > > ... hrm... I would probably use some sort of progress meter on the long-running page you might want to halt -- which will slow it down some overall also, although probably not a noticeable amount in most cases... What you really need is a way to interract with the running page from the client side -- which means, another page load, which is fine, it's just a matter of figuring out how that is accomplished... The fileexists() isn't a bad idea -- you could for instance have a "stop" button that produces a popup window that says "stopping the process, please wait", which then creates the halt flag on the server. Use cfflush after the button is displayed and before the long running process begins, so that the button is visible and then display the progress below the button. When the long running process sees the flag file it deletes it, aborts the process, closes the popup window and displays a message indicating that the process has been cancelled. I wouldn't worry terribly much about the time it takes to perform the fileexists() function -- it should be unnoticeable. If you'd like an easy to implement progress indicator, there's one in the Tapestry API in my sig file. > > hth > > s. isaac dealey 972-490-6624 > > new epoch http://www.turnkey.to > > lead architect, tapestry cms http://products.turnkey.to > > tapestry api is opensource http://www.turnkey.to/tapi > > certified advanced coldfusion 5 developer > http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
