>- see footer for list info -< Woo sarcasm in the commuinty. Notice my Paul Fennell spelling of community there. The spelling that resulted in my having to change huge amounts of code, queries, stored procedures, table names in a cetain community web site full of spelling mistakes ...... Grrrrrr
Russ > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Robertson-Ravo, Neil (RX) > Sent: 21 April 2005 08:32 > To: [EMAIL PROTECTED]; Coldfusion Development > Subject: RE: [CF-Dev] Download a returned recordset > > >- see footer for list info -< > No, really....? > > > <sarcasm/> > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Paul Fennell > Sent: 20 April 2005 17:41 > To: 'Coldfusion Development' > Subject: RE: [CF-Dev] Download a returned recordset > > >- 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 -< > 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 -<
