Thanks guys!
I went with
<cffile action="WRITE" file="#g_EcountFileDirectory#\#eCountFilename#"
output="#ecount_header#" addnewline="Yes">
<cfloop query="fetchReferrals">
<cffile action="APPEND"
file="#g_EcountFileDirectory#\#eCountFilename#" output="#record_data#"
addnewline="Yes">
</cfloop>
<cffile action="APPEND"
file="#g_EcountFileDirectory#\#eCountFilename#"
output="#ecount_footer#" addnewline="Yes">
Still takes a few minutes but it didnt crap out on me this time.
Thanks!
On Mon, 22 Nov 2004 10:03:29 -0800, Ian Skinner
<[EMAIL PROTECTED]> wrote:
> This won't help with your timeout issue, but you can see how far you are
> getting.
>
> <cfloop query="fetchReferrals">
> <cfif fetchReferrals.currentRow EQ 1>
> <cffile action="WRITE"
> file="#g_EcountFileDirectory#\#eCountFilename#"
> output="#ecount_header##ecount_file##ecount_footer#" addnewline="Yes">
> <cfelse>
> <cffile action="APPEND" file="#g_EcountFileDirectory#\#eCountFilename#"
> output="#ecount_header##ecount_file##ecount_footer#" addnewline="Yes">
> </cfif>
>
> This would at least write out each row. Give you an idea of how much you
> need to increase your timeout in the administrator to allow this process to
> run.
>
> --------------
> Ian Skinner
> Web Programmer
> BloodSource
> www.BloodSource.org
> Sacramento, CA
>
> "C code. C code run. Run code run. Please!"
> - Cynthia Dunning
>
> Confidentiality Notice: This message including any
> attachments is for the sole use of the intended
> recipient(s) and may contain confidential and privileged
> information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the
> intended recipient, please contact the sender and
> delete any copies of this message.
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185053
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
