I usally have a Subroutine that runs everytime someone visits a page, but
you can also use global.asa.
Example:
Sub TimedOutSessions()
If Application("Debug") Then
Response.Write("<b>Called TimedOutSessions():</b><br />")
End If
Dim strSQL
strSQL = "UPDATE [tblSessions] SET ysnOnline = False WHERE dtmActive NOT
BETWEEN #" & DateAdd("n", (-1 * Application("SessionTimeout")), dtmNow) & "#
AND #" & dtmNow & "#;"
Dim objCnn
Set objCnn = Server.CreateObject("ADODB.Connection")
objCnn.ConnectionString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=" &
Server.MapPath("database.mdb") & ";"
objCnn.Open()
objCnn.Execute(strSQL)
objCnn.Close()
Set objCnn = Nothing
End Sub
On 11/18/05, goriojuan <[EMAIL PROTECTED]> wrote:
>
> Does anyone know how to determine if the user's session has been
> expired. I want to set a record status to "0" if the user leaves the
> page. But how can i do this if the user leaves by session timeout? Help
> is greatly appreciated.
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/u8TY5A/tzNLAA/yQLSAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
