1 Correct answer
Explorer
,
Jun 16, 2006
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 ...
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 ...
2
Replies
2
2
Replies
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#>
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#>
Resources
Documentation
AdChoices