Logging users - ASP Tutorial

Home > Asp > Tutorials > Logging users - ASP Tutorial

Tell a friend

Link to us

Total Members

Members: 84606

Home

1 . Introduction to ASP

2 . Setting up your ASP environment

3 . First ASP Page

4 . Active Server Objects

5 . Global.asa

6 . Application Object

7 . Session Object

8 . Request Object

9 . Response Object

10 . Server Object

11 . ASP Server Side Includes

12 . Connecting to a database

13 . Returning a recordset from a database

14 . Formatting a recordset as a HTML table

15 . Populating a dropdown list from a database

16 . Creating an automated email

17 . Sending attachments via an automated email

18 . What is the FileSystemObject?

19 . Total number of users are accessing the ASP application?

20 . Logging users

Asp Group Home

Asp Discussion (86)

Asp Members (23063)

Asp Resources

Asp Source Code (238)

- Asp Unanswered Questions

GROUPS

.NET

Java

Other

TUTORIALS

.NET

.NET Tutorial

ASP Tutorial

ASP.NET Database Tutorial

ASP.NET Development Tips

ASP.Net Security,Internationalisation And Deployment

ASP.NET Server Controls Tips

Web Development

Software Development

Java

Java Web Component Tutorial

JSP And J2EE Design Tutorial

RESOURCES

SUBMISSIONS

COMMUNITY

SITE

Asp Tutorial

Logging users

<< Prev: Total number of users are accessing the ASP application?

To log a user,set up a table with the following fields,UserID,Action,ActionDateTime. Ensure you have the user's id or name in a session e.g. session("userid")= request.Form("UserID") and then insert a record and the action that they perform like the example below.

<%
set oConn=server.createobject("adodb.connection")
oConn.open "DSN=MyDSN"

updatedate = FormatDateTime(Now,0)
sSQL = "INSERT tblUserAction (UserID,Action,ActionDateTime) VALUES ('" & session("userid") & "','Logged on','" & updatedate & "')"
oConn.Execute (sSQL) %>