... hmmm... a long running query is a tougher issue... If you're talking about a stored procedure you could theoretically do something similar with a temp row in a table where the procedure checks for a flag after each particular event in the procedure. Unfortunately this may result in error's in the cf page also...
For an individual query it becomes rather obscure -- it's going to depend heavily on which rdbms (or just plain database) you're using, and there may not be a really good way to do it, but I'd say find a decent users forum for your chosen database and ask them for resources regarding stopping a running query. Again -- liable to cause errors in the ColdFusion code. hth > 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/uns > ubscribe.cfm?user=633.558.4 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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
