You query might be breaking? Try removing the query and just write
something to a file, something really simple like "SESSION ENDED". That
way at least you will know that the session ended and was not erroring
out. 


......................
Ben Nadel
Certified Advanced ColdFusion MX7 Developer
www.bennadel.com
 
Need ColdFusion Help?
www.bennadel.com/ask-ben/

-----Original Message-----
From: Richard Cooper [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 05, 2006 9:41 AM
To: CF-Talk
Subject: Re: onSessionEnd function not getting called

Still not working :(

I've tried including the new code such that the onsession end now looks
like:

<cffunction name="OnSessionEnd" access="public" returntype="void"
output="true" hint="Fires when the session is terminated.">
        <cfargument name="SessionScope" type="struct" required="true" />
        <cfargument name="ApplicationScope" type="struct"
required="false" /> <cfinclude
template="../../../customtags/getSessionList.cfm">
<cfif
StructIsEmpty(getSessionList(Arguments.ApplicationScope.applicationname)
)>
        <cfquery name="changeStatus" datasource="#REQUEST.theDatabase#">
        UPDATE  companyDetails
        SET             status = 'INTERMITTANT'
        WHERE   companyID = <cfqueryparam value="#REQUEST.companyID#"
cfsqltype="cf_sql_integer" />
        </cfquery>

</cfif>

</cffunction>

I didn't change any other code within the file. I had a look at the
adobe docs for this and it used AppScope which I also tried but still no
joy. 

Do I need to make amendments elsewhere in the doc to get this to work?



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262897
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to