<--- --------------------------------------------------------------------------------------- ---- Blog Entry: Tracking Data Audits In ColdFusion Author: Ben Nadel / Kinky Solutions Link: http://www.bennadel.com/index.cfm?dax=blog:1271.view Date Posted: Jun 25, 2008 at 9:25 AM ---- --------------------------------------------------------------------------------------- ---> UPDATE contact SET first_name = , last_name = , title = , company = WHERE id = INSERT INTO contact ( first_name, last_name, title, company ) VALUES ( , , , ); SELECT ( LAST_INSERT_ID() ) AS id ; INSERT INTO contact_audit ( date_audited, id, first_name, last_name, title, company )( SELECT , c.id, c.first_name, c.last_name, c.title, c.company FROM contact c WHERE c.id = ); SELECT a.pkey, a.date_audited, a.id, a.first_name, a.last_name, a.title, a.company FROM contact_audit a WHERE a.id = ORDER BY a.pkey DESC ColdFusion Audit Table Demo

ColdFusion Audit Table Demo

Name:

Title:

Company:


Contacts Audits

First Name Last Name Title Company Date
#qAudit.first_name#
 #qAudit.last_name#
 #qAudit.title#
 #qAudit.company#
 #DateFormat( qAudit.date_audited, "mm/dd/yy" )# #TimeFormat( qAudit.date_audited, "hh:mm TT" )#