CF code in unload event

[nfitz]

I have some CF code that I want to execute when a user leaves a page. I put it
in a javascript OnUnload routine. However the code seems to be executing when
the page loads as well. I set the agent status = 'I', then load the page, and
the status is set to 'O'. Does anyone know why this code executes before the
unload event???? Thanks. function jsUnload(){ <CFOUTPUT> <CFQUERY
NAME='qAgentPhone' DATASOURCE='#application.dsnCommon#'> UPDATE
tblAgentStatus SET AgentIn = 'O' WHERE AgentUserName =
'#session.AgentUserName#' </CFQUERY> </CFOUTPUT> } }

[cf_menace]

Javascript and CF do not interact that way.

If you view the source of your resulting HTML page, all that will appear is

function jsUnload(){

}
}

The CFML code is processed on the server before the final HTML content is sent
to the browser. The <cfquery> is in no way tied to the Javascript function
jsUnload().

[zoeski80]

You could call a JS function on Unload which calls a CFM page which opens a new
window which will run the appropriate code.
I use that in the FRAMESET onUnload to log the user out of the system.
<FRAMESET onUnload="logoff();">

If you have CF 7 you can have an Application.cfc page in which you can setup
onApplicationStart/End, onSessionStart/End, onRequestStart/End code - this may
be what you're after??

HTH

Zoe

[nfitz]

We only have 5, so I will try the frameset unload idea. I think that will work for us as well. Thanks much!!