Page not found error

[LStead]

I've just upgraded from CF 5.0 to CF MX 7.0. One of my CF scripts that includes
looping through a DB query does not work well anymore. Under CF 5.0 on Win 2K
it worked fine. Now under CF MX 7.0 on Win 2003 it starts off fine (displays
page header) but then seems to timeout and then browser displays a page not
found error. If I then run it again right away, it works fine. I know the query
takes a long time (large DB with a complex view).

I've tried changing the query timeout, and I've turned off the timeout in CF
administrator, but I still get the same problem.

There must be some IIS 6.0 setting that needs to be changed. I've played with
some settings in the metabase, but they had no effect either.

Has anyone seen this problem before? If so, what was the cure?

Thanks.

Lloyd.

[LStead]

I found a solution by flushing a space out to the browser for every loop through the query. That seems to keep the browser from timing out. Go figure.

Thanks.

Lloyd.

[Dan Bracuk]

Now that I see how you solved it, we have experienced something similar. What
we found was, on long jobs, if the browser has nothing to do for a couple of
minutes, it will send another http request and the job starts again. We solved
our problem with the occasional flush.

In your case, flushing a space each time through the loop might give you more
spaces than you really want on the final web page. You might want to use the
mod operator to reduce the flush to every hundreth iteration or so.