Hi James,
Good Morning. Thanks for your response.
I didn't check the forum this morning. Actually what I did I
am forming the string which will generate comma seperated value. I
am keeping on concatenating it. It is due to memory problem
(buffer). I found that I am getting this error. Later I went and
resetting the variable.
For. Eg.
My string is
<cfset TabChar = Chr(9)>
<cfoutput>
<!--- set content type to invoke text --->
<cfcontent type="html/text">
<!--- open file and Write --->
<cffile action="write"
file="#GetTempDirectory()#sample.txt"
output="Q1#Tabchar#Q2#TabChar#">
<!--- Taking savecontent as variable and storing the
values --->
<cfloop query="query">
<cfset savecontent= savecontent &
"#TabChar##query.column1#">
<cfif query.column1 NEQ "">
<cfset savecontent = savecontent & #TabChar# &
#query.column1#>
<cfelse>
<cfset savecontent = savecontent & #TabChar#>
</cfif>
<cfif query.column2 NEQ "">
<cfset savecontent = savecontent & #TabChar# &
#query.column2#>
<cfelse>
<cfset savecontent = savecontent & #TabChar#>
</cfif>
<!--- … and so on. At the end of it I am writing
into the text file --->
</cfloop>
</cfoutput>
<CFHEADER NAME="Content-Disposition" VALUE="attachment;
filename=sample.txt">
<CFCONTENT TYPE="application/unknown" DELETEFILE="Yes"
FILE="#GetTempDirectory()#sample.txt" RESET="Yes">
Later I changed the code as
<cfset TabChar = Chr(9)>
<cfoutput>
<!--- set content type to invoke text --->
<cfcontent type="html/text">
<!--- open file and Write --->
<cffile action="write"
file="#GetTempDirectory()#sample.txt"
output="Q1#Tabchar#Q2#TabChar#">
<cfloop query="query">
<!--- Taking savecontent as variable and storing the
values --->
<cfset savecontent="#id##TabChar#">
<cfset savecontent= savecontent &
"#TabChar##query.column1#">
<cffile action="append"
file="#GetTempDirectory()#sample.txt" output="#savecontent#">
<!--- in my previous code I keep appending the variable
savecontent. Now I am not (storing new value of savecontent)--->
<cfif query.column1 NEQ "">
<cfset savecontent = #TabChar# & #query.column1#>
<cfelse>
<cfset savecontent = savecontent & #TabChar#>
</cfif>
<cffile action="append"
file="#GetTempDirectory()#sample.txt" output="#savecontent#">
<cfif query.column2 NEQ "">
<cfset savecontent = #TabChar# & #query.column2#>
<cfelse>
<cfset savecontent = savecontent & #TabChar#>
</cfif>
</cfloop>
</cfoutput>
<CFHEADER NAME="Content-Disposition" VALUE="attachment;
filename=sample.txt">
<CFCONTENT TYPE="application/unknown" DELETEFILE="Yes"
FILE="#GetTempDirectory()#sample.txt" RESET="Yes">
Have a nice day
Thanks
Satheesh
<cffile action="append" file="#GetTempDirectory()#sample.txt"
output="#savecontent#">
<cfset savecontent = #TabChar# & #query.column1#>