>- see footer for list info -< Can you not just cache the query and then it will be available for the excel file if necessary?
On 4/20/05, Stephen Adams <[EMAIL PROTECTED]> wrote: > 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 -<
