Dude Normalize the table.. 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
-- Regards, Kamiru Mwangi, 0721792419 Skype: samuel.kamiru