Ok I am not that well versed on Stored Procedures yet. Let me try to explain and see if anyone has any suggestions. I have a table of members, with all their address info etc. THe member may come to the web page and change whatever fields they wish. The database is then updated. Now what i would like to then do is write to another table Change_Log each field that was change it's OLD value and it's NEW value.
Now obviously if they are doing this via a form (using Cold Fusion) even if a field doesn't change it will be submitted in the update statement. Is there an easy way to write stored procedure that will then check what fields were chagned and grab the old value, the new value and the field name and insert that into the change_log table. I know it can be done just don't know how to go about doing it. Any suggestions or advice would be appreciated. Thanks Kelly Matthews ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
