Aidan
The way I've got round this before is to output the "Your report is being
generated" page with a javascript function at the bottom that just does a
self.location to the page which actually creates the report -
e.g.
pleasewait.cfm
--------------
<cfoutput>
Your report is being created - please wait....
<BR>
<img src="hourglass_anim.gif">
<script language="javascript">
self.location.href = 'make_and_display_report.cfm';
</script>
</cfoutput>
It's always worked OK for me.
Alistair Davidson
Senior Developer
Rocom New Media
www.rocomx.net
"There is no spoon"
-----Original Message-----
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 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
report to be finished.
The report generation needs to be triggered on-demand. Updating a CFSCHEDULE
and then running it straight away doesn't seem to work (I guess because it
must be set at least 15 minutes in the future).
Calling the report making template via CFHTTP before using CFLOCATION
doesn't work, as the page sits there until the report is finished before
redirecting.
Using CFHTTP at the end of the "your report is being created" also makes
that page take forever to be rendered. If I was using CF5, I guess I could
CFFLUSH the page before doing CFHTTP last, but we're stuck with v4.0.1.
I can't call CFML.EXE via a URL and CFEXECUTE is only 4.5+.
Any ideas? I've run out...
Thanks.
--
Aidan Whitehall <[EMAIL PROTECTED]>
Macromedia ColdFusion Developer
Fairbanks Environmental +44 (0)1695 51775
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
