At one of my clients, the content providers each look after an allocated part of the data used for displaying information on the web site. They want to be able to export their data to a spreadsheet so they can review it and update it off line. These are not IT people but experts in their various consumer fields. They want me to put a button in their admin areas for each category of comsumer data so it will export the data for them automatically. I was going to do it this way and I wondered if there was a better way:
(1) Have a spreadsheet already attached to CF as a datasource. (2) Use a CFQuery to delete all the records in that datasource. (3) CFQUERY the SQL7 table the content provider wants to export (4) loop through the query, inserting the data into the (now blank) spreadsheet. (5) Use CFMail to email the spreadsheet to the user (getting their email address from their logon details). I seem to remember a function or a tag that output the results of a query into spreadsheet format but I can't find any reference to it any more. Can anyone enlighten me? Is this the easiest way? Will CFMail be able to send the spread sheet or will I need to unlock it from the server first? in which case, how can i do that automatically? Cheers, Mike Kear AFP Webworks, Windsor, NSW, Australia ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
