Store users and date time after login

What do you mean "store the users"?

What do you mean "store the users"?

Insert the username and date when they logged in after a successfully login.

Hi,
to insert new record to another table use this code:

str = "insert into TableName (field1,field2) values ('" & Session("UserID") &',now())"

Hi,

I received the follwoing error message
Microsoft VBScript compilation error '800a03ea'
Syntax error

DSN:
set CN = server.CreateObject("ADODB.Connection")

CN.Open "DSN=NTSS;UID=user;PWD=pwd"

set rs = Server.CreateObject("ADODB.Recordset")

rs.Open "insert into LoginHistory (LoginName, LoginDate) values (" & "'" & Session("UserID") & "'" & "," & "'" & Now() & "')", CN

CN.Close

set CN = Nothing

set rs = Nothing
using dbconnection:
strSQLInsert = "insert into LoginHistory (LoginName, LoginDate) values (" & "'" & Session("UserID") & "'" & "," & "'" & Now() & "')"

dbConnection.Execute strSQLInsert

• this is for MSSQL where non Int (varchar etc) needs to be quoted ('foo')

DSN:

• this is for MSSQL where non Int (varchar etc) needs to be quoted ('foo')

Thank you very much this worked so perfect thanks again.