Hi guys, I have a rather nice app running now with CGI::App, HTML::temp and CGI::Sess... It displays fairly large chunks of data from a mysql db. (sometimes up to 1500 lines of data.) Anyway, I now have a small problem and I was wondering if you guys had a suggestion... I need to put a link on the DB displays where they can download the data in csv format (comma seperated values so the winblows newbies get an excel icon appear when the download it.) Anyway, I don't want to create the file unless they are gonna use it.. because it will take resources to create a file that might not be used, and its slowish already.. (need to upgrade the server soon.) I thought about creating a runmode for the csv that receives the relevant query data from the runmode that refered to it... and does the query again, this time printing to file while in the fetchrow loop... then print a download header and start the download... I am thinking there might be an easier way to do this, but not sure what it is... Does anyone have any suggestions here??? There are currently ten screens that will require a download link, so I'd like to write reusable code so all of them just use the same sub or runmode... What have you guys done in cases like this??? rgds Frank --------------------------------------------------------------------- Web Archive: http://www.mail-archive.com/suppressed/ To unsubscribe, e-mail: suppressed For additional commands, e-mail: suppressed
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.