Anurag S
|
| Posted: 02/13/2002, 2:40 AM |
|
Dear Sir,
How do I maintain a Log Reocrd database of Users of a system using CodeCharge.
Log_Database table structure is :
UserID
Login_Date
Login_Time
Logout_Time
Working_Time
Please Help Me.
Anurag Seetha
|
|
|
 |
Alex Alexapolsky
|
| Posted: 02/13/2002, 3:42 AM |
|
1) Create user login table fields you mentioned above(Login time etc. +UserID).
2) Events you need to use are :
onLogin (Or cutom login with "obtain generated code" button clicked) , OnLogout
Insert code that will add or update a record in those event. E.g. in OnLogin event (just a sample , may not work):
cn.execute ("insert into logins (userid,login_time,logout_time) values (" & session("UserID")& ",now(),null)")
|
|
|
|
|
