A really simple bit of quick dev code
To deliver a quick excel doc is giving my a bit of hassle
---------------------
<CFSET tempfile = "D:\report1.csv">
<cfif fileexists('tempfile')>
<cffile action="DELETE" file='#tempfile#'>
</cfif>
<CFFILE ACTION="WRITE" FILE='#tempfile#'
OUTPUT="FirstName,Surname,JobTitle,CompanyName,Product,email">
<cfloop query="qry_getall">
<CFFILE ACTION="APPEND" FILE='#tempfile#'
OUTPUT="#FirstName#,#Surname#,#JobTitle#,#CompanyName#,#Product#,#email#
">
</cfloop>
<cfoutput>
<a href="report1.csv">report - Excel </a>
</cfoutput>
Now this all works nice an fine
And the correct excel sheet each time on the server is fine
However it if you recall the code with a new query the file is updated
to the new data however the browser still servers the old excel file
Ok some thing is caching here there is no cache on the server so is
there an extra Param I can add to ensure that the browser gets the
updated excel sheet with out having to add a rand to the file name ??
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
