RE: Generating reports in the background (update)

2001-11-01 Thread Aidan Whitehall
> Are you using SQL Server and making full use of its power with > [snip] > sorry if any of this sounds like bad news to you. I'm using Access. Go on. Laugh. However, this only needs to tie us over for about 8 weeks. After that, we'll be moving our main database from Sybase's Adaptive Server Any

Re: Generating reports in the background (update)

2001-11-01 Thread Patrick Harkins
Aidan: Frankly I am not surprised you are having trouble Reports can put a serious load on the CF interpreter. Some questions to ask are: Are you using SQL Server and making full use of its power with views (and calculated columns?), stored procedures, triggers, etc.. Have you considered

RE: Generating reports in the background (update)

2001-11-01 Thread Aidan Whitehall
> Let the invisible frame run the .cfm report and notify > the visible frame when it's done. > After being notified, the visible page doesn't load > the reports page directly (this would run the report > all over again). Instead, it load the variable into > which the reports page has stored all

RE: Generating reports in the background (update)

2001-10-31 Thread cf refactoring
Aidan, The key is not to do an immediate redirect. If you do that, it's just running the CF page all over again. Let the invisible frame run the .cfm report and notify the visible frame when it's done. After being notified, the visible page doesn't load the reports page directly (this would r

RE: Generating reports in the background (update)

2001-10-31 Thread Aidan Whitehall
> I'd suggest the following > > >This displays "Your report is being > generated". It contains javascript that reloads itself > every 15 seconds and checks to see whether a variable > session.reportDone EQ TRUE. If yes, it returns the > contents of session.reportResults >this calls your

Re: Generating reports in the background (update)

2001-10-31 Thread cf refactoring
I'd suggest the following This displays "Your report is being generated". It contains javascript that reloads itself every 15 seconds and checks to see whether a variable session.reportDone EQ TRUE. If yes, it returns the contents of session.reportResults this calls your report.cfm page. r

RE: Generating reports in the background (update)

2001-10-31 Thread Alistair Davidson
ssage- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: 31 October 2001 11:44 To: CF-Talk Subject: Re: Generating reports in the background (update) I'm trying to trigger a ColdFusion template that generates a report in the background. I want to start the process and then redirect t

RE: Generating reports in the background (update)

2001-10-31 Thread Pascal Peters
--Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: woensdag 31 oktober 2001 12:44 To: CF-Talk Subject: Re: Generating reports in the background (update) I'm trying to trigger a ColdFusion template that generates a report in the background. I want to start the p

Re: Generating reports in the background (update)

2001-10-31 Thread Aidan Whitehall
I'm trying to trigger a ColdFusion template that generates a report in the background. I want to start the process and then redirect the browser to a "your report is being created" page. Try as I might, I can't get the report started without the browser being forced to wait at some point for the r