Registrer dato og tid ved login

Du kan lave en update som opdater lastlogin

sql = "UPDATE [users] set lastlogin=Now() where (username = '" & Request("username") & "') and ([password] ='" & Request("password") & "')"

og ligge det ind i denne if sætning:

  strSQL = "SELECT * FROM users where (username = '" & Request("username") & "') and (password ='" & Request("password") & "')"
  Set ez = myConn.Execute(strSQL)
    Session("login") = "" & Request("username") & ""
    EZ.Close
    RS.Close
    Conn.Close
  End if


Sådan her:


  strSQL = "SELECT * FROM users where (username = '" & Request("username") & "') and (password ='" & Request("password") & "')"
  Set ez = myConn.Execute(strSQL)
    Session("login") = "" & Request("username") & ""
    sql = "UPDATE [users] set lastlogin=Now() where (username = '" & Request("username") & "') and ([password] ='" & Request("password") & "')"
    myConn.Execute(sql)
    EZ.Close
    RS.Close
    Conn.Close
  End if

Virker perfekt...

Mange tak for hjælpen...