The first thing that jumps out at me would be to have hidden form fields in the form that contain the original values. Then, when you're processing the form any value that doesn't match its corresponding hidden value has been changed.
thanks, eric cobb ecar technologies, llc http://www.cfgears.com Blizzm wrote: > We have several lengthy forms that are going to be used for updating records > and various data. We are also looking at recording which form fields have > been updated. Is there a means for updating only those records which have > changed? > > I was thinking of looping through a form collection, comparing submitted vs. > existing database values, storing any changed values and then having a CFC > process the SQL update. If this is a good starting point, how would I be > able to update only those fields that need to be changed? > > For example if I have 100 fields and only 10 have been updated, how can I > write a query to update only those 10 fields? > > Thanks in advance. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331555 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
