• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

My page generates an Excel file but sometimes fails if the page loads to slowly...

New Here ,
Jun 22, 2006 Jun 22, 2006

Copy link to clipboard

Copied

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 cfcontent tags.

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 appreciated!
TOPICS
Advanced techniques

Views

260

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jun 22, 2006 Jun 22, 2006

Copy link to clipboard

Copied

stick this at the top of your page
<cfsetting requesttimeout="500">
HTH
--
Tim Carley
www.recfusion.com
info@NOSPAMINGrecfusion.com

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jun 22, 2006 Jun 22, 2006

Copy link to clipboard

Copied

LATEST
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, thanks.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation