Hi, I'm trying to make a trigger that checks to see if some fields were updated and then does some thing if they were.
I've tried using the updated function which seems to just check if the fields were in the update statement as opposed to checking to see if the fields were actually changed. I think anyway. So, I'm thinking I have to use the deleted and inserted magic tables. Is there an easy way to write a statment that checks if the value was changed? I guess I'm looking for some nice syntax. -- DRE www.webmachineinc.com www.theanticool.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186888 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54