A report I'm outputting to XLS is from a logging table which even on a single day may have 5000++ records. I was taught to output to xls by using cfcontent and creating a simple table for output, which would put it in the spreadsheet (works well).
The select query from the db I'm using takes around .5-.6 seconds when timed with cftick. But it can take 10 minutes to load into the browser/xls -- if it loads at all and doesn't just lock up my browser which it usually does. This is for one DAY of records, never mind I gotta provide a research firm several months of this data in xls format. I think maybe it's the gigantic table-to-xls. Is there a better way of doing this? Is there some delimited char I could use in the output under the cfcontent tag that would read into separate cells like the table does? I didn't want to output to delimited and then import to xls as that does require some review of the data and I didn't wanna review a couple hundred thousand records to be sure it was all perfect. Many thanks for any advice. I feel like I've learned more from people on this list in the last month than I ever have in six without the helpful folks here. Regards, Palyne ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
