Dave Watts wrote: >>>> I shouldn't complain too much, as they don't care how >>>> much it costs and pay quickly - but, is there a more >>>> efficient way of doing this? >>> triggers. >> AJAX. Field-based editing with a simple log. =] > > I'm sorry, but that, by itself, is a very silly answer. > > AJAX is display technology. It lets you build a more responsive, less linear > presentation layer. It doesn't let you track database changes any more than > a traditional HTML interface lets you track database changes.
I agree that it is certainly an incomplete answer. I suspect what the poster meant was to attach an onChange call to all the fields on the form that are being used to display and change data. Have the call do an async request to the server with the field id, before value and after value that gets fed into a logging function. For validation purposes, I would also add the id of that field to a hidden form field listing the fields that were changed and then compare the changed values to the original values that were sent out. That step, however, could just replace the Ajax bit entirely. My 0.02 Judah ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270276 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
