2. ASPRunnerPro General questions
  3. Insert into Security Table
This topic is locked

Insert into Security Table

 		11/11/2004 2:20:34 PM
ASPRunnerPro General questions
D
 dpkona author

Has anyone modified the _edit page to insert database changes into an Audit table? If so, can you provide your methodology to me?
thanks in advance
Sergey Kornilov admin 11/15/2004

Hi,
you can use something like this:

strSQL = "insert into Audit (Username, LoggedIn) values ('" & Session("UserID") & "', Now())" 

dbConnection.Execute strSQL


This code inserts the name of logged user and a timestamp into Audit table.