There is a User Defined Function on cflib.org that will to the trick too...
http://www.cflib.org/udf.cfm?ID=404 CSVFormat, it works like a charm. Check it out! Justin Hansen -------------------------- Uhlig Communications Web Developer / Programmer -------------------------- [EMAIL PROTECTED] 913-754-4273 -------------------------- -----Original Message----- From: James Blaha [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 4:54 AM To: CF-Talk Subject: Issue: How to Create a CSV file from a CF QUERY Hello All: Could someone please send me some example code or a custom tag for creating a CSV file from a CF QUERY? I need to be able to have a user be able to download or email information to him or her on a request. I need to have a page that will allow a user to extract information from a SQL7 table in CSV format and they should either be able to download this live data when they click a link or be able to enter there email address and the cfm will query the live information in the table produce a csv file and then email the user the information as an attachment. That latter would be preferred. Thanks in advance, James Blaha 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 ______________________________________________________________________ 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
