Once the login part is done, you can roll your own solution quite easily.
Create a table which has the same columns as the table you want to track,
plus user ID and timestamp columns and a column called say "opCode" which
can be I for Insert, U for Update or D for delete.
Then every time you do an UPDATE/INSERT/DELETE via a CFQUERY (or better,
CFSTOREDPROC) add a row to this table with the user ID and timestamp,
opcode, and a copy of the row they inserted, or a copy of the row they
deleted, or a copy of the row they updated, as it was *before* they
updated it.
Now you have a full audit trail.
Nick
-----Original Message-----
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 20, 2000 1:24 PM
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
