we are using a complete log solution for this purpose.
say, in a page, we execute a sql statement
strsql = "insert into emp (name,no,sal) values ('"& name & "......
conn.execute strsql
what we do here is, we add this to a log table
conn.execute "insert into log_table (userid,log,timestamp) values ('" &
session("userid") & "',"' " & strsql & "',#" & now & '"#)"
Ilyas
-------Original Message-------
From: samson kumar
Date: 04/26/05 11:26:48
To: [email protected]
Subject: [ASP] record updation history
Dear friends,
The website is for online updations.Users are restricted. I want to find out
the user, date and time of updation of records online.so that i can catch
him if he updates with wrong information.I am using sessions.
I have 2 fields in ms-access database as modifierId and modified_DateTime.
Can you give any idea, how can i write code to it.
Thanks in advance. ~Samson.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [email protected]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
.
[Non-text portions of this message have been removed]
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [email protected]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
