>- see footer for list info -< I think I'll just go with the cached query idea.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 20 April 2005 16:42 To: 'Coldfusion Development' Subject: RE: [CF-Dev] Download a returned recordset >- see footer for list info -< Or you could convert it to xml then use an appropriate xsl stylesheet to transform to xls, pdf, beer etc. Although it may be a bit processor intensive.. K > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:dev- > [EMAIL PROTECTED] On Behalf Of Tomo > Sent: 20 April 2005 15:32 > To: Coldfusion Development > Subject: Re: [CF-Dev] Download a returned recordset > > >- see footer for list info -< > or you could go the vile route of generating HTML tables and renaming > the file xls... > > how long does poi take to install and configure? > > > Robertson-Ravo, Neil (RX) wrote: > >>- see footer for list info -< > > > > What if the data contains commas already...I know you can escape > > them etc..but seems like such a pain in the arse...POI ....fast and > effective.. > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Tomo > > Sent: 20 April 2005 16:09 > > To: Coldfusion Development > > Subject: Re: [CF-Dev] Download a returned recordset > > > > > >>- see footer for list info -< > > > > what's wrong with a CSV? > > > > Robertson-Ravo, Neil (RX) wrote: > > > >>>- see footer for list info -< > >> > >>Depending on what it is you can get strange results when outputting > >>to Excel. We use POI for Query to Excel and Excel to Query but we > >>are on MX > - > >>you may be able to use it on CF5 though just a little more > >>convoluted I would think. > >> > >>http://jakarta.apache.org/poi/index.html > >> > >>This is very fast, very reliable. > >> > >> > >> > >>-----Original Message----- > >>From: [EMAIL PROTECTED] > >>[mailto:[EMAIL PROTECTED] On Behalf Of Simon > >>Baynes > >>Sent: 20 April 2005 15:50 > >>To: Coldfusion Development > >>Subject: Re: [CF-Dev] Download a returned recordset > >> > >> > >> > >>>- see footer for list info -< > >> > >>Why are you using a structure? Just output the results form the > >>query to the page. > >> > >>Does your query change much? If not the cache it and that will save > >>database hits. > >> > >>On 4/20/05, Stephen Adams <[EMAIL PROTECTED]> wrote: > >> > >> > >>>>- see footer for list info -< > >>> > >>>Hi, > >>> > >>>I have a query which displays a large number of result, anywhere > between > >> > >>500 > >> > >> > >>>to 1800. Now not only do I want to display the results in my page. > >>>I > want > >> > >>to > >> > >> > >>>allow the user to download this result set into an Excel file. > >>> > >>>The idea I am thinking of using is placing the results into a > >>>structure > >> > >>and > >> > >> > >>>then using this structure to loop through in one page to display > >>>the results, and then when the user decides they wish to download > >>>this > result > >>>set, loop through the structure again in another file creating the > >> > >>download > >> > >> > >>>excel file, using cfhttp and cfcontent. > >>> > >>>But I am worried about the performance of this, will this method be > >>>to > >> > >>slow, > >> > >> > >>>is there another way I could do this. Unfortunately the site is > >>>running > on > >>>CF5, no CF7, bugger! > >>> > >>>Stephen > >>>_______________________________________________ > >>> > >>>For details on ALL mailing lists and for joining or leaving lists, > >>>go > to > >> > >>http://list.cfdeveloper.co.uk/mailman/listinfo > >> > >> > >>>-- > >>>CFDeveloper Sponsors:- > >>> > >>> > >>>>- Hosting provided by www.cfmxhosting.co.uk -< > >>>>- Forum provided by www.fusetalk.com -< > >>>>- DHTML Menus provided by www.APYCOM.com -< > >>>>- Lists hosted by www.Gradwell.com -< > >>>>- CFdeveloper is run by Russ Michaels, feel free to volunteer your > help > >> > >>-< > >> > >>_______________________________________________ > >> > >>For details on ALL mailing lists and for joining or leaving lists, > >>go to http://list.cfdeveloper.co.uk/mailman/listinfo > >> > >>-- > >>CFDeveloper Sponsors:- > >> > >> > >>>- Hosting provided by www.cfmxhosting.co.uk -< > >>>- Forum provided by www.fusetalk.com -< > >>>- DHTML Menus provided by www.APYCOM.com -< > >>>- Lists hosted by www.Gradwell.com -< > >>>- CFdeveloper is run by Russ Michaels, feel free to volunteer your > >>>help > -< > >> > >>This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, > >>Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed > >>Business, Registered in England, Number 678540. It contains > >>information which is confidential and may also be privileged. It is > >>for the exclusive use of > > > > the > > > >>intended recipient(s). If you are not the intended recipient(s) > >>please > > > > note > > > >>that any form of distribution, copying or use of this communication > >>or > the > >>information in it is strictly prohibited and may be unlawful. If > >>you > have > >>received this communication in error please return it to the sender > >>or > > > > call > > > >>our switchboard on +44 (0) 20 89107910. The opinions expressed > >>within > > > > this > > > >>communication are not necessarily those expressed by Reed Exhibitions. > >>Visit our website at http://www.reedexpo.com > >>_______________________________________________ > >> > >>For details on ALL mailing lists and for joining or leaving lists, > >>go to > > > > http://list.cfdeveloper.co.uk/mailman/listinfo > > > >>-- > >>CFDeveloper Sponsors:- > >> > >> > >>>- Hosting provided by www.cfmxhosting.co.uk -< > >>>- Forum provided by www.fusetalk.com -< > >>>- DHTML Menus provided by www.APYCOM.com -< > >>>- Lists hosted by www.Gradwell.com -< > >>>- CFdeveloper is run by Russ Michaels, feel free to volunteer your > >>>help > -< > >> > >> > > > > > > _______________________________________________ > > > > For details on ALL mailing lists and for joining or leaving lists, > > go to http://list.cfdeveloper.co.uk/mailman/listinfo > > > > -- > > CFDeveloper Sponsors:- > > > >>- Hosting provided by www.cfmxhosting.co.uk -< > >>- Forum provided by www.fusetalk.com -< > >>- DHTML Menus provided by www.APYCOM.com -< > >>- Lists hosted by www.Gradwell.com -< > >>- CFdeveloper is run by Russ Michaels, feel free to volunteer your > >>help > -< > > > > This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, > > Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed > > Business, Registered in England, Number 678540. It contains > > information which is confidential and may also be privileged. It is > > for the exclusive use of > the > > intended recipient(s). If you are not the intended recipient(s) > > please > note > > that any form of distribution, copying or use of this communication > > or > the > > information in it is strictly prohibited and may be unlawful. If > > you > have > > received this communication in error please return it to the sender > > or > call > > our switchboard on +44 (0) 20 89107910. The opinions expressed > > within > this > > communication are not necessarily those expressed by Reed Exhibitions. > > Visit our website at http://www.reedexpo.com > > _______________________________________________ > > > > For details on ALL mailing lists and for joining or leaving lists, > > go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > > > -- > > CFDeveloper Sponsors:- > > > >>- Hosting provided by www.cfmxhosting.co.uk -< > >>- Forum provided by www.fusetalk.com -< > >>- DHTML Menus provided by www.APYCOM.com -< > >>- Lists hosted by www.Gradwell.com -< > >>- CFdeveloper is run by Russ Michaels, feel free to volunteer your > >>help > -< > > > > > > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go > to http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your > >help - > < _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
