[thelist] [ASP Question] Session_OnStart

Jacques Capesius jacques_capesius at cnt.com
Fri Oct 18 11:10:01 CDT 2002

Hi folks,

I'm trying to do a little stat collecting, using a Session_OnStart trigger
to record in a database the time someone first accessed the site. I figure,
having a global.asa file that looked like this would do the trick...

Sub Session_OnStart
	Set SessionCon = Server.CreateObject("ADODB.Connection")
	SessionCon.Open "Driver={SQL Server}; SERVER=blaa;
DATABASE=whatever; UID=jondoe; PWD=aintellin;"
	SQLQuery = "INSERT INTO Session_stats (sessionID, session_start) "&_
			   "VALUES ('"&Session.SessionID&"',getdate())"
	set theRS = SessionCon.Execute(SQLQuery)
	set theRS = Nothing
	set SessionCon = Nothing
End Sub

As is probably obvious to some of you ASP Wizards, this code isn't
executing, and i'm not really sure why. I'm kinda new to adding code to the
global.asa file and using ASP's version of event handling, so any advice you
folks could give would be greatly appreciated. thanks!

More information about the thelist mailing list