WhoKnows
Posts: 4
|
| Posted: 02/21/2007, 3:45 AM |
|
 Anyone help please (novice user - very novice)
I have an application based on an SQL database with a users login table containing 3 fields - UserName, Password and SecurityLevel.
I would like to be able to review basic information such as ... Who logged in and when. With my limited knowledge, I realise that I can review the web logs, but these do not indicate the user name.
Thanks in advance ......
|
 |
 |
wkempees
|
| Posted: 02/21/2007, 12:09 PM |
|
Check this first:
http://forums.codecharge.com/posts.php?post_id=60821&s_keyword=logging
Walter
"WhoKnows" <WhoKnows@forum.codecharge> schreef in bericht
news:645dc30d2130cf@news.codecharge.com...
> Anyone help please (novice user - very novice)
>
> I have an application based on an SQL database with a users login table
> containing 3 fields - UserName, Password and SecurityLevel.
>
> I would like to be able to review basic information such as ... Who
> logged in
> and when. With my limited knowledge, I realise that I can review the web
> logs,
> but these do not indicate the user name.
>
> Thanks in advance ......
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
DeanCovey
Posts: 22
|
| Posted: 02/21/2007, 7:01 PM |
|
I had a project where I just wanted to track the last date/time the user logged in. I created a field in the user table named LastLogin. The when the user clicks the login button, then
If CCGetUserID>0 Then dbConnection.Execute("UPDATE Individuals SET LastLogin=#" & now() & "# WHERE id=" & CCGetUserID)
dbConnection = your db + name of connection.
|
|
|
|
WhoKnows
Posts: 4
|
| Posted: 02/26/2007, 9:12 AM |
|
Hi Walter
re.......Check this first:
http://forums.codecharge.com/posts.php?post_id=60821&s_keyword=logging
I like your idea of creating a separate table to hold details of each login. However, I couldn't get it to work.
Is it possible you could advise me of the ASP code (using an SQL database) for this solution.
Thanks
|
|
|
|
|
