>- 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 -<
