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:244462 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
