Did you put your header line in a cfoutput block? You'll need to do that because of the cfsetting tag that's there.
***************** Ken Ferguson 214.636.6126 ***************** [EMAIL PROTECTED] wrote: > Is there a way to get a header row on the example below? I tried putting > one above the <Cfoutput> with no luck. Otherwise it works like a charm. > The file gets fairly large. Does creating a 15 meg file with 110,000 > records put a major load on the server? I tried the other java examples > but could not get them to work with an automatic file prompt. > > Lee > > > -----Original Message----- > From: Tanguy Rademakers [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 20, 2006 2:39 PM > To: CF-Talk > Subject: Re: Export text > > > <cfsetting enablecfoutputonly="true" showdebugoutput="false"> > <cfquery name="testqry" datasource="sc_rhea"> > select ID, ITEM_CONTENT_ID, REFERS_TO_ITEM_ID, EXTERNAL_REFERENCE > from SC_ITEM_REFERS_TO where id < 135000 > </cfquery> > > <cfheader name="Content-Type" value="text/plain"> > <cfheader name="Content-Disposition" > value="attachment;filename=sample.txt"> > <cfoutput > query="testqry">#ID#,#ITEM_CONTENT_ID#,#REFERS_TO_ITEM_ID#,#EXTERNAL_REF > ERENCE# > </cfoutput> > > posting this from the website, so watch the formatting: it should be > > <cfoutput query="xyz">#col1#,[EMAIL PROTECTED] all on one line][hard return] > </cfoutput> > > /t > ..houseoffusion.com/tiny.cfm/54 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244472 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
