You can use <cfcontent> to export your results to Excel.
Things in general to watch out for with large numbers of query results are: 1. Too many records can overwhelm the browser. As a rule of thumb, we won't display more than 1000 records on a web page. 2. Even excel has a limit. For Excel 97 you are restricted to 65,536 rows. If your query is running slow, look at your sql and your database design. Maybe the answer is to add an index or something like that. **************** I have problem with a query that I am doing in access with CF. The query is returns a lot of records and causes the browser (netscape 4.78 and the network security won't upgrade!) to go "not responding" for a while then it produces the query results. The query comes out as one table, they want to see all the records in one page. Any suggestions on how to make this run better so the users browser doesn't crash or give them the impression that it has crashed? Does having the whole query result in one table slow things down? Providing that the above is a problem that the results are just to big. Can anyone tell me how convert my query results in to an Excel Spread and produce a link that the can download. - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: [EMAIL PROTECTED] To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
