list session id's and visit time

samwisegamgee16 · August 22nd, 2007, 08:42 PM

I IIS, i need to use the Global.asa file and another page named page2.asp to display all the session id's and the time they visited the website.
Im unsure of whether i need to use the session or application object, whether to use variables etc..
So far i have only come up with this, but of course it doesnt work:
Global.asa

Code:

<SCRIPT LANGUAGE="VBScript" RUNAT="Server">
       sub Application_OnStart()
                DIM sessionStarted()
             sessionStarted= TIME()
             Application("sessionTime") = SessionStarted
       end sub

Server.Transfer("page2.asp")
</SCRIPT>

page2.asp

Code:

<html>
<head>
<title>List of sessions</title>
</head>
<body>
<%
LocalArray = Application("sessionTime")
Response.Write(LocalArray) & "<br />"
%>
</body>
</html>

any help would be muchly appreciated.

mat41 · August 22nd, 2007, 09:10 PM

I would use a DB table and do the insert in the global.asa file. IMO why use the time function, the now function will give you the date time. Depending what you are trying to achieve this gives you much more options for obvious reasons.

Anyhow this is one way to achieve your objective (IMO a much better one. Why not store the values so you can do analysis etc.....):

<script runat=server language=VBScript>
Sub application_onStart

end sub

sub session_onStart
    application.lock
    Set Conn = Server.CreateObject("ADODB.Connection")
    GetConnectionString = "Provider=SQLOLEDB.1; Password=someString; Persist Security Info=True; User ID=someOtherString; Initial Catalog=yourDBName; Data Source=yourPCName"
    Conn.Open GetConnectionString
    SQL = "INSERT INTO sessionStartTime (dt) VALUES('" & now() & "');"
    Conn.execute(SQL)
    Conn.close
     set Conn = nothing
    application.unlock
End Sub

Sub Session_OnEnd

End Sub

Sub Application_OnEnd

End Sub

</script>

Wind is your friend
Matt

samwisegamgee16 · August 22nd, 2007, 09:26 PM

thanks, that shall be useful.. any ideas how to use the global.asa file though??

mat41 · August 22nd, 2007, 09:33 PM

That code I posted is a global.asa file

Wind is your friend
Matt

samwisegamgee16 · August 23rd, 2007, 02:32 AM

Quote:

quote:Originally posted by mat41
That code I posted is a global.asa file

Wind is your friend
Matt

oh it is too, sorry, my bad :) thanks for ur help