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:185050
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

Reply via email to