I am storing some variables as session variables in my application. Then, I
am trying to store these variables into en MS SQL 2000 DB whenever a timeout
happens. I am trying to do it accessing these session variables from
application.cfc and passing these variables to a Store Procedure that, in
turn, stores the values into my database. My code in application.cfc 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="netmetriks.spAgregarPaginasSalida"
datasource="NMdata">
<CFPROCPARAM type="IN" dbvarname="@ID_periodo"
value="#Arguments.SessionScope.PERIODO#" cfsqltype="CF_SQL_CHAR">
<CFPROCPARAM type="IN" dbvarname="@ID_cuenta"
value="#Arguments.SessionScope.CUENTA#" cfsqltype="CF_SQL_SMALLINT">
<CFPROCPARAM type="IN" dbvarname="@ID_pagina"
variable="#Arguments.SessionScope.PAGINA#" cfsqltype="CF_SQL_INT">
<CFPROCPARAM type="IN" dbvarname="@Time"
variable="#Arguments.SessionScope.TIEMPO#" cfsqltype="CF_SQL_INT">
</CFSTOREDPROC>
</cffunction>
</cfcomponent>
It is not working. My question is: is it possible? What am I doing wrong?
Thank you a lot!
Fernando.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211606
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
