yep, that's also an option... I am not envisaging a HUGE download all of the time as the where clause should actually limit the amount of data coming back.......
-----Original Message----- From: Tom Smith [mailto:[EMAIL PROTECTED]] Sent: 04 February 2003 15:53 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Suggestions Neil, Why don't you write it to a file, and have the file writing run on a schedule, so that the report is generated during slow periods on the site - so as not to have an effect on other services/processes. This way the file will most always be available as a downloadable item. Cheers, TOM ----- Original Message ----- From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 04, 2003 3:39 PM Subject: RE: [ cf-dev ] Suggestions > Cheers Matt, > > Yep, I have tried this but with over 2,500 lines of code it can crash Excel > by hanging it. I am thinking I will just save out the table of data to a > txt file and then get it to be imported into Excel like Steve uses. > > > > > > > > -----Original Message----- > From: Matt Horn [mailto:[EMAIL PROTECTED]] > Sent: 04 February 2003 15:37 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Suggestions > > > export to Excel bung this in the top of your report page > > <CFIF isdefined("form.submitit")> > <CFHEADER name="Content-Disposition" > value="Filename=Foo#rand()#z.xls"> > <CFCONTENT type="application/vnd.ms-excel"> > </CFIF> > <FORM name="Test" method="post" action="MyPage.cfm"> > <INPUT type="hidden" name="submitit"> > <INPUT type="submit" value="Excel "> > </FORM> > > where Mypage.cfm is the report page > > > > At 15:27 04/02/2003 +0000, you wrote: > >in fact it appears that by saving the HTML, Excel can in fact import the > >data......cracking, but is this advisable... > > > >-----Original Message----- > >From: Robertson-Ravo, Neil (RX) > >[mailto:[EMAIL PROTECTED]] > >Sent: 04 February 2003 15:26 > >To: '[EMAIL PROTECTED]' > >Subject: [ cf-dev ] Suggestions > > > > > >OK, I need suggestions.......(on CF45). > > > >I have a report which is being generated via a CT which calls the DB and > >then builds the HTML table - 2.5K rows (and modifies some data results via > >CFML), I now need to get the table as an end-result (i.e. variables changed > >depending on values/parameters) into either an Excel or Text file..... I am > >at a roadblock as far as the next step.. > > > >Anyone got the best idea/approach to this before I simply leave and get > >drunk..... > > > >N > > > >-- > >** 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] > > > -- > ** 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] __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- ** 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]
