2. ASPRunnerPro General questions
  3. Tracking Users
This topic is locked

Tracking Users

 		4/3/2006 3:10:51 PM
ASPRunnerPro General questions
N
 npala2001 author

I have a table titled "tbl_User_Tracking" with three columns, "login_number" <- (Autonumber Field), "UserID" and "Login_Time". Once a user logs in I want the users information to be entered into this table for tracking purposes. Any help? <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=2708&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
Sergey Kornilov admin 4/3/2006

Use AfterSuccessfulLogin Event. Something like this will work.

Sub AfterSuccessfulLogin()

'********** Insert a record into another table ************

strSQLInsert = "insert into tbl_User_Tracking (UserID, Login_Time) values ('" & Session("UserID") & "', now())"

dbConnection.Execute strSQLInsert
End Sub
N
 		npala2001 author 4/3/2006

Thanks it worked! You guys are the best
R
 		roller 6/30/2006

Sorry, but where does this code go?
J
 		Jane 7/4/2006

Ian,
use this code in the AfterSuccessfulLogin event on the Events tab (step 11) in the ASPRunner.