I'm having a problem generating an Excel file using CF and
looping over a bunch of queries to get a table of data to display
to the user. This is slow but works fine except for an instance
recently where the page seems to be loading but after a few minutes
it stops and says "the page cannot be displayed". The error leads
me to believe it is a server error and not a CF error but I'm not
sure. I don't have timeout checked in my CF Admin so that should
mean that I can request pages for as long as I need to right?
I'm using the cfheader and cfcontent to dynamically generate
an Excel spreadsheet from my HTML. I tried using the cfflush tag
and that seemed to help since it pushes content to the browser
during the page load but it doesn't work with the cfheader and
So then I tried using the cfsavecontent tag and then save the
HTML to a file but again I couldn't use the cfflush tag inside the
cfsavecontent tag so now I'm stuck.
The page DOES load when I run in on my local machine with MX
6.1 Developer Edition and SQL Server Personal Edition. It DOES NOT
work when I run it on my production server that then calls my
separate database server. I'm wondering if there is a timeout (non
CF) set somewhere on the productions server or the database server
or if there is some sort of limit to the amount of data you can
transfer between servers?
I'm totally stumped now so any advice is greatly
That didn't work for me and the page times out right about 5
minutes (300 seconds). I don't have timeout checked in the CF
Administrator so I don't think it is CF that is causing the
timeout. I checked IIS also and the timeout is set to 900 seconds.
Is there a possibility that SQL Server has some sort of
connection limit and I'm using too many cfquery tags? If anyone has
experienced a similar problem I would really appreciate the help,