If you get rid of cfconent then load the page in a browser does it render as a normal CF page such that if you view source you see exactly the content that you expect to see in a CSV file?
If it is a text file then use a regular line break instead of a BR tag. -Mike Chabot On Wed, Nov 5, 2008 at 8:08 PM, Toby King <[EMAIL PROTECTED]> wrote: > I have a program - very simple to query a db and geta result set and save to > a CSV verything seemend to work OK initially but when I run the program now I > keep getting a message cannot download the .cfm file. > > Here is the code. > > <cfquery name="getUsers" datasource="#request.AppDS#"> > SELECT * > FROM Users > order by lastname > </cfquery> > > <!--- Now output as simple comma-separated text ---> > <!--- Put the column names on first line, then ---> > <!--- the actual data rows on their own lines ---> > > <cfheader name="Content-Disposition" value="Attachment; > filename=scusers3.txt"> > > <cfcontent type="text/plain">"Title","FirstName","LastName","Email"<br /><br > /> > <cfoutput query="getUsers">"#Title#","#FirstName#","#LastName#","#Email#"<br > /></cfoutput> > > > THanks in advance for any feedback. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314891 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
