>- see footer for list info -< I was thinking of a structure, because I am going to need the result set in two places, one where I display it to the user and the other when I create a Excel/CSV file if the user plans to download the results.
-----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 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 -<
