You can't do that on retrospect. But going forward if you have legacy issues to keep you from doing it properly, what you can do is create a table to store login and logout times and then add a trigger to the original table to insert this data On Wed, Nov 24, 2010 at 4:09 PM, Simon Mbuthia <simon.mbuthia@gmail.com>wrote:
Hi Skunksters,
I need help. I have a table that has a list of all created users of a certain system. Other fields in the table are whether or not the user is logged in, the name of the computer that he is logged on to and the time that he logged in and out. The problem is that if some user XYZ logs in at 9 AM and logs out at 9:15 AM, then later on logs in at 12 noon and logs out at 1 PM, the initial record that he had logged in between 9 and 9:15 is erased.
My question is: Is there a way that I can tell from the logs, perhaps or elsewhere what the record contained before it was overwritten?
Me.
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke