Skip to main content
A
apocalipsis19
Inspiring
February 25, 2009
Answered

CFContent Situation

  • February 25, 2009
  • 4 replies
  • 872 views
Hello community!

I am working on an export file which is a pipe (|) delimited file and I am running into some issues. First of all the file is not being generated with the file name that I am specifying. Second, I am getting a ton of HTML in addition to my data in my generated file. I want a clean export -That is only the data from my query. This export is for a third party product that we use in my company.

This is where I generate the file:

<cfcontent type="text/plain">
<cfheader name="Content-Disposition" value="\\development\webdata\retail\cigars\filename=famoussmoke_#timeNow#.txt">
<cfoutput>
<br />
<cfloop query="getFields">

#adr#|#fname#|#lname#|#zip#|#ordnum#|#tot_goods#|#suppflgs#<br />

</cfloop>
</cfoutput>
Can somebody provide me with some assistance?

Thanks!
This topic has been closed for replies.
Correct answer JR__Bob__Dobbs-qSBHQ2
Things to try:

For a text file use Chr(13) & Chr(10) instead of a BR tag.

You will also need to remove whitepace prior to your content by using reset="yes" in your CFCONTENT tag. Also remove any whitespace such as line breaks after your CFCONTENT tag.

I think your CFHEADER tag is also a problem. Are you trying to download the text to your browser or save it to a file share?

Edit: Modified code sample.

4 replies

A
apocalipsis19Author
Inspiring
February 27, 2009
The problem was here:

value="attachment;filename=famoussmoke.txt"

I didn't have the word attachment in the value paramater.

Thank you guys! Your feedback and support were awesome!
A
apocalipsis19Author
Inspiring
February 25, 2009
Hi JR!

Yes, I want to download the file to my desktop. It's not being downloaded with the name I specified though..........See cfheader tag...Thanks soooo much!
J
JR__Bob__Dobbs-qSBHQ2
Inspiring
February 25, 2009
See attached sample. Note that the attachment value for Content-Disposition is only recognized by some browsers, such as Internet Explorer.
N
Newsgroup_User
Inspiring
February 25, 2009
First, I *think* you want to put the <cfheader> before the
<cfcontent...> tag, but I am not user.

But definatly, if you do not want HTML in your output, don't put it
there! You are formating you content as HTML with <br/> and such, but
then telling the browser that it is not HTML with the type="text/plain".
Go one way or the other, don't mix the message.

<cfheader
name="Content-Disposition"
value="\\development\webdata\retail\cigars\filename=famoussmoke_#timeNow#.txt">
<cfcontent type="text/plain">
<cfoutput
query="getFields">#adr#|#fname#|#lname#|#zip#|#ordnum#|#tot_goods#|#suppflgs#
</cfoutput>


NOTE: It is very hard to experss in this email, but since you are
saying this output is plain text, not HTML, then all white space is
going to count. So you will have to be very careful with what you put
in and around your <cfoutput...> tags. They will show up!
A
apocalipsis19Author
Inspiring
February 26, 2009
Ok, let me try the other way around and I will post in here how it goes!
J
JR__Bob__Dobbs-qSBHQ2Correct answer
Inspiring
February 25, 2009
Things to try:

For a text file use Chr(13) & Chr(10) instead of a BR tag.

You will also need to remove whitepace prior to your content by using reset="yes" in your CFCONTENT tag. Also remove any whitespace such as line breaks after your CFCONTENT tag.

I think your CFHEADER tag is also a problem. Are you trying to download the text to your browser or save it to a file share?

Edit: Modified code sample.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices