>- see footer for list info -< That's what I am going to go for. The user can then open the file in excel or some other program they have.
-----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 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 -<
