ok.. that's quite a different idea.. i haven't thought of that.. will try thanks!
-----Original Message----- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2003 11:25 AM To: CF-Talk Subject: RE: How To Delete Recs After loading of crystal report (URGENT) > hi Issac, > actually that's exactly what i'm doing, using a temp > table to drive the data out. However now, i need to > delete the data from the table after its been loaded by > the report as the data contains confidential data. What > would u recommend? In all honesty I don't have a whole lot of suggestions -- it's not an issue I've dealt with before. The only thing that springs to my mind is a scheduled task. If you create it and have it run every 15 minutes or so however the potential will always exist that it will run just between someone hitting the link for the report and when the Crystal engine starts retreiving. If you know that the report will never take more than say 1-2 minutes, you can use <cfschedule> to schedule the template to run 1-2 minutes after the template initiates the Crystal engine. > -----Original Message----- > From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] > Sent: Monday, March 31, 2003 10:40 AM > To: CF-Talk > Subject: Re: How To Delete Recs After loading of crystal > report (URGENT) > It's probably a complex query... I've heard that crystal > reports has a big > problem with complex queries as a result of it doing > something like > (pseudocode): > WHILE EXISTS (SELECT blah blah > FROM blah blah WHERE blah blah > AND primarykey NOT IN (somelist)) > SELECT TOP 1 blah blah > FROM blah blah WHERE blah blah > AND primarykey NOT IN (somelist) > somelist = somelist + newkey > ) > That's what I've heard anyway. I've actually seen it tank > a reasonably > powerful server with what looked like a reasonably simple > query just because > of some basic join statements... It's entirely possible > that could have been > a result of a poor understanding of Crystal, I don't know, > I'm not a Crystal > expert myself. Their solution was to create a temporary > table to hold the > data drawn from the "complex" query and use that temp > table to drive the > report. I prefer using HTML for reports and if necessary > publishing them to > PDF myself. >> If you're using SQL Server, you can put your results into >> a temporary table. >> But why are you putting the report data into a table in >> the first place? >> Why not just do a select statement? >> ----- Original Message ----- >> From: "JAIME HOI" <[EMAIL PROTECTED]> >> To: "CF-Talk" <[EMAIL PROTECTED]> >> Sent: Sunday, March 30, 2003 6:30 PM >> Subject: How To Delete Recs After loading of crystal >> report (URGENT) >>> Hi >>> Does anyone knows how to delete records from a >>> table >>> after crystal >> report completed loading its report? i tried using >> CFX_WAIT however , it >> deleted the records before the report was able to >> retrieve >> it and display >> it. >>> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> ~ >> ~~~~~~~~~~~| >> 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 954-776-0046 > 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 > Structure your ColdFusion code with Fusebox. Get the > official book at http://www.fusionauthority.com/bkinfo.cfm > Unsubscribe: http://www.houseoffusion.com/cf_lists/uns > ubscribe.cfm?user=633.558.4 s. isaac dealey 954-776-0046 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
