Hi Just following on from what Issac said, if the query can be done within a loop, (perhaps using a cursor) in a stored proc you can check the temporary table on each execution and if a particular flag or row exists you can then decide to roll back the whole transaction (if that's what you want). This will obviously perform much slower than one single query but gives you the flexibility to abort the process by inserting a record in the temporary table. I've done this before and it works well
Kola >> -----Original Message----- >> From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] >> Sent: 09 June 2003 23:41 >> To: CF-Talk >> Subject: Re: Mechanisms for stopping a running script >> >> ... 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
