Hi,
It's simple... on every login, keep the user's Id in a session
variable. When that user updates a record simply pass this Id
in the modifierId, and the current date and time (using the
Now() function) to the modifier_DateTime field as part of your
UPDATE query.
Regards
Kamran
--
--- samson kumar <[EMAIL PROTECTED]> wrote:
>
>
> 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]
>
>
>
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------------------------------------------------
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/
