Hello Illyas,
Thanks for your answer. It's really nice idea.
I think I should have one table with Id(autonumber), RecordID, ModifierId,
ModifiedDate/Time. Through "Insert Query" I Should Insert fields as soon as I
login.
However It's nice idea.I will try it and come back..
Thanks
~Samson.
---------------
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 the Yahoo! Terms of Service.
---------------------------------
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
[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/
