>- see footer for list info -< Yep...you always get that really annoying leading zero issue etc....
But I suppose nothing you cannot work around... -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Russ Michaels (Snake) Sent: 20 April 2005 16:22 To: 'Coldfusion Development' Subject: RE: [CF-Dev] Download a returned recordset >- see footer for list info -< Excel will except plain old HTML formatted tables, just set the header to say it's an excel file and it should open in excel. Any of the cf_excel tags should show u a good example. Russ > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Robertson-Ravo, Neil (RX) > Sent: 20 April 2005 16:10 > To: Coldfusion Development > Subject: RE: [CF-Dev] Download a returned recordset > > >- 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 -< 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 -<
