The project I'm working on requires Journaling, i.e., track changes made to the data.
I'm hoping to do this as a blackbox. My beginning plan is to duplicate the query that loads the form to a session variable. Then, when the form submits, compare the submitted data to the original data and write any changes to a journal table. Since the form may contain elements that are not in the table, it seems to me I need to walk the form getting the name of each FORM.Item and then seeing if that item exists in the duplicated query (I'm giving form elements the same name as the table row elements; that, of course, doesn't apply if I use, say, a hidden input for something that doesn't have a corresponding row element). When you cfdump a query or a form it seems there is some kind of structure there that I should be able to walk for this info but the syntax escapes me. Any ideas? Larry Stephens ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336405 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm