>- see footer for list info -< -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Repeating yourself doesn’t make it correct. - -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robertson-Ravo, Neil (RX) Sent: 20 April 2005 17:04 To: Simon Baynes; Coldfusion Development Subject: RE: [CF-Dev] Download a returned recordset >- see footer for list info -< http://jakarta.apache.org/poi/index.html - -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Simon Baynes Sent: 20 April 2005 16:34 To: Coldfusion Development Subject: Re: [CF-Dev] Download a returned recordset >- see footer for list info -< Pardon my ignorance but what is POI? On 4/20/05, Tomo <[EMAIL PROTECTED]> wrote: > >- 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 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 -< - -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.16 - Release Date: 18/04/2005 - -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.16 - Release Date: 18/04/2005 -----BEGIN PGP SIGNATURE----- Version: PGP Personal Privacy 6.5.3 iQA/AwUBQmaGElA768D4gVAEEQLbzgCeNMW8wW8hY7GFUeSkWdz2tAcofH0An3tK wMPvtouehXaqxiyep2CFkgQ0 =GDHo -----END PGP SIGNATURE----- _______________________________________________ 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 -<
