For a more normalized approach ;)
Have a table that you insert into which has a few columns
tablename, userid, timestamp.
Now.. if you are talking about tracking individual changes that
makes it a little more complex and gets into some no fun stuff.
This would involve archiving every row as it is changed which
would quickly make the DB huge.
You will need a "log" table which you log the current table row
and who modified it and THEN update the changes to your current
table. This will create a complete log of all changes who made
them and when. This is the most simple approach.
There are a couple other approaches, this is probably the most
simple :-)
Jeremy Allen
ElliptIQ Inc.
-----Original Message-----
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 20, 2000 8:24 AM
To: CF-Talk
Subject: Is this possible w/CF???
I have a client that needs a real simple app. A form that lets a user modify
records in a database. Easy. Except, they want to have a record of which
user made what changes! How in the heck is this possible? Is it?
We would have a table of users, and they would log in first. There would be
less than 30 users to keep track of. I can imagine keeping track of when
they log in, but how to track what changes are made?
Do I look into a CF or Database function??
Any help on this would be great.
Jeff Fongemie
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists