cfgrid and cfgridupdate... archieving changes

[SilentBob'secretfusion]

Hi,

I am attempting to use the very cool cfgrid command for the first time.
However, my problem is the following:

I want to archieve all changes. For example, if a user edits a first name, I
want that entire row archieved, so if it was a screw up, we can go back and
check the data. Any suggestions how and if this can be done. It appears that
the cfupdate will update the table and no archieve is made of the old table.
Thanks.

[SilentBob'secretfusion]

I guess I could place a trigger on the data base side to archieve changes.
However, I could I get the information on the user? Perhaps, what I could do
is execute the trigger when the cfgridupdate is run. Then after the
cfrgridupdate, insert into the table the userid. Hmmm.

I am just wondering how I am going to sync these trigger table with the userid
who made the change. Any ideas?