If I understand the question correctly. Off the top of my head .... I would save a copy of the data that you used to populate the form as a struct in the session scope and when the form is submitted you can compare the form to the saved struct using the structCompare() from cflib.org
http://www.cflib.org/udf/structCompare HTH G On Fri, Jun 26, 2009 at 12:56 PM, Nathan Chen <[email protected]> wrote: > > Hi, All: > > > > I am building a form that allows users to edit data retrieved from > multiple tables. There are many fields in the form. If the users don't > change anything and hit the cancel button, then I don't need to do the > update, otherwise several sql update statements will be executed. Is > there an easy way to detect if users have made changes to the data in > cfform rather than comparing each field to the original data? > > > > Nathan > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:323988 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

