Yes, Ravi is correct. If CF is not connected to your webserver, the
CFML will not run at all, and data will not be inserted.
Are you doing some kind of cfheader/cfcontent, or javascript relocate
somewhere?
I'm thinking if your code does something like this:
1. get the XML
2. parse through it
3. do your cfcontent, or serve up another page that results in the
blank file
4. loop through your data and insert into DB
1 and 2 is why it takes a while to have that dialog box to save
index.cfm come up.
3 is what makes that dialog box come up
4 keeps on going because the request has been made. You've confirmed
this in MySQL. It's like a user going to "long_running_page.cfm", and
then not waiting for the page to load and navigate to
"any_other_page.cfm". "long_running_page.cfm" is still executing on the
server, even though the user is totally unaware of it (most users anyway).
If it was the web connector, then the cfm file would never execute, and
just get served up like ordinary html, by either displaying the unparsed
cfml, or asking the file to be saved.
[STS] Ravi Gehlot wrote:
> It is weird that it asks you to save the index.cfm file. The only time I had
> that problem was when IIS was not configured to open CFM files. Same had
> happened with Apache. But since you are saying that the process are running
> on the background with data being inserted into the database it makes me
> think that this is not a problem of adding CFM to IIS/Apache Index
> Directory.
>
> Ravi.
>
>
>
>
> On Sun, Apr 13, 2008 at 7:30 AM, Rick Faircloth <[EMAIL PROTECTED]>
> wrote:
>
>
>> I remember getting that error when trying to complete a
>> long-running cfftp request.
>>
>> It's been awhile, and I'm not sure what actually solved the issue,
>> but I did look back at the file and remember adding
>> <cfsetting requesttimeout="60000">
>> to the code at the top of the page.
>>
>> Perhaps setting a high requesttimeout will help.
>>
>> If I think of something else, I'll pass it on to you.
>>
>> Rick
>>
>>
>>> -----Original Message-----
>>> From: Randy Johnson [mailto:[EMAIL PROTECTED]
>>> Sent: Sunday, April 13, 2008 12:15 AM
>>> To: CF-Talk
>>> Subject: weird issue in browser with cf8 and long execution times
>>>
>>> Hello,
>>>
>>> I am running CF8 Standard.
>>>
>>> I am running a page that takes a few minutes to run. After a certain
>>> amount of time a gray box will popup and ask me to save the index.cfm
>>>
>> file
>>
>>> or open it. When I open it or save it the file is always blank.
>>>
>>> When this happens it looks like the page is done executing in the
>>>
>> browser
>>
>>> but if you look in the task manager you see that JRUN is still using the
>>> CPU. I have also confirmed that the page is still running by doing a
>>> refresh in Navicat which shows that more rows are being added to the
>>> database table.
>>>
>>> The page is reading an XML file, parsing it and then looping over to
>>>
>> insert
>>
>>> data into the database.
>>>
>>> Has anyone seen this before or know what I need to do to stop it from
>>> happening?
>>>
>>>
>>> Thanks!
>>>
>>> Randy
>>>
>>>
>>>
>>>
>>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303267
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
