add a rand to the url this ensures the browser gets freshest version > -----Original Message----- > From: Paul Fennell [mailto:[EMAIL PROTECTED] > Sent: 19 March 2003 10:26 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] - cffile > > > > > 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#,#Produc > t#,#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] >
-- ** 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]
