2. ASPRunnerPro General questions
  3. [SOLVED]  Capture windows authentication (login ID)
This topic is locked
[SOLVED]

 Capture windows authentication (login ID)

 		1/20/2005 10:55:32
ASPRunnerPro General questions
L
 laboria author

Is there a way to capture a users Windows authentication (login ID) and put it in the database when the user edits or adds information?
Thanks for such a wonderful program!
swat 1/20/2005

Add this to file_login.asp -

strSQL = "insert into logins (Username) values ('" & Session("UserID") & "')"  

dbConnection.Execute strSQL
L
 		laboria author 1/21/2005

Unfortunately, this did not work for me. Maybe I inserted it in the wrong place in the code. Where should it be located?
Sergey can you please assist us?
Thanks!
Sergey Kornilov admin 1/22/2005

Hi,
you can add a field where you like to store user name who updated the record to the edit page setting Edit as type to Hidden. Set Default value for this field to Session("UserID") or to Request.ServerVariables("AUTH_USER").
L
 		laboria author 1/26/2005

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=3207&image=1&table=forumreplies' class='bbc_emoticon' alt=';)' /> Thanks Sergey!

That is just what the Doctor ordered.
You are "da man" <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=3207&image=2&table=forumreplies' class='bbc_emoticon' alt='B)' />