>- 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 -<
