glad I could help. :) > 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/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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
