it could be anywhere from 0 to 10,000+ (extreme case), use maybe one a month, possibly more.....
-----Original Message----- From: Tom Smith [mailto:[EMAIL PROTECTED]] Sent: 04 February 2003 16:10 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Suggestions how many records are you returning? and what's the use going to be like? ----- Original Message ----- From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 04, 2003 4:01 PM Subject: RE: [ cf-dev ] Suggestions > not at all...any suggestion at mo is good....maybe it can kickstart me..... > > uurgh > > > zzzzzzzzzz > > -----Original Message----- > From: Tom Smith [mailto:[EMAIL PROTECTED]] > Sent: 04 February 2003 16:01 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] Suggestions > > > oh, I forgot you want to do loads with it... sorry, my point is a waste of > time then. > ----- Original Message ----- > From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, February 04, 2003 3:50 PM > Subject: RE: [ cf-dev ] Suggestions > > > > 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] > > __________________________________________________ > 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] __________________________________________________ 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]
