Try CF_Query2Excel tag - works very well if you can't find it on Macromedia send me another email - I've got a copy here somewhere
Seamus At 05:23 pm 3/04/02 , you wrote: >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 > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
