OnSessionEnd

[fernimac]

I am programming an application, and I would like to file in a database the
exact time at which a visitor arrived to a certain page and then shut the
browser or his session timed out. Is it possible to write the data through an
Insert into the database from an OnSessionEnd event in my application.cfc file?

Thank you.

Fernando.

[mpwoodward *TMM*]

On 2005-07-08 10:41:45 -0500, "fernimac" <webforumsuser@macromedia.com> said:

> I am programming an application, and I would like to file in a database
> the exact time at which a visitor arrived to a certain page and then
> shut the browser or his session timed out. Is it possible to write the
> data through an Insert into the database from an OnSessionEnd event in
> my application.cfc file?
>
> Thank you.
>
> Fernando.

You can put whatever you want in your onSessionEnd event--as far as I
know there aren't any real limitations. Did you try it and run into
problems?

Matt
--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[fernimac]

Hi Matt,

I have a page that stores some values as session variables. Then, I am trying
to store those values into a database whenever a timeout happens through a
stored procedure. My code is as follows:

<cfcomponent>
<cfset This.name = "MyApp">
<cfset This.SessionManagement = "yes">
<cfset This.SessionTimeOut = "#createtimespan(0,0,15,0)#">
<cfset This.ApplicationTimeOut = "#createtimespan(5,0,0,0)#">
<cfset This.setClientCookies = "yes">
<cfset This.ClientManagement = "true">
<cfset This.ClientStorage = "cookie">
<cffunction name="onSessionEnd" returnType="void">
<cfargument name="SessionScope" required=True/>
<CFSTOREDPROC procedure="spAddPage" datasource="Mydata">
<CFPROCPARAM type="IN" dbvarname="@ID_per"
value="#Arguments.SessionScope.PER#" cfsqltype="CF_SQL_CHAR">
<CFPROCPARAM type="IN" dbvarname="@ID_acct"
value="#Arguments.SessionScope.ACCT#" cfsqltype="CF_SQL_SMALLINT">
<CFPROCPARAM type="IN" dbvarname="@ID_pag"
variable="#Arguments.SessionScope.PAG#" cfsqltype="CF_SQL_INT">
<CFPROCPARAM type="IN" dbvarname="@Time"
variable="#Arguments.SessionScope.TIME#" cfsqltype="CF_SQL_INT">
</CFSTOREDPROC>
</cffunction>
</cfcomponent>

But it does not seem to work. What am I doing wrong?

Thank you a lot.

[fernimac]

Everything works just fine. I had two typos in my code.

Thank you anyway.