As another option you could cache the queries for 24hours.
<cfquery name="my_query" datasource="my_datasource"
CachedWithin="#CreateTimeSpan(1,0,0,0)#">
-- Sam
-----Original Message-----
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 2:35 PM
To: CF-Talk
Subject: output cf to html
I have this Huge Honking report....
written in cf
it shows exactly what i want.
but i don't want a user to run this report every time they hit the page.
i would like to know how to
have cf-server
run the page...
but just save it to html
every night.
so that it gets updated basically once a day.
instead of hitting the db every time some one views the cfm page..
any ideas?
-paul
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
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
