I've done something like that. My method was to have a hidden form field with the original data and compare it to the submitted data.
<input type="text" name="userName" value="#variables.userName#"> <input type="hidden" name="userName_orig" value="#variables.userName#"> <!--- Action page ---> <cfif form.userName neq form.userName_orig> <!--- Add username to data to update ---> ... </cfif> Of course, I'd loop on form.fieldnames (or a custom list of field names to check) so I wouldn't have to repeat the same code for every field. Another option might be to use JavaScript to disable the unchanged fields. Disabled fields aren't in the FORM scope of the action page. -----Original Message----- From: Richard White Sent: Monday, September 25, 2006 1:54 PM To: CF-Talk Subject: Posting variables Hi, i am used to programming standalone computer applications not internet applications and would really appreciate some advice. I have a form with quite a few fields (text boxes etc...) on it. For additiional HCI, when the user edits the form from pre-exsting data, i like to have the fields all green, then if they edit some of the fields they turn red, to show that the changed data needs to be saved. To lesson the load on the database interation, i would like to program it so that when the user clicks save changes, it only updates the database based on the fields that are red. This is quite simple in standalone computer apps as i just code it to look for the fields that are red, but of course with the internet apps i cant check this as when the user clicks submit the fields are gone. Can anyone give me some advice on how this can be done. I am a bit lost with this. Thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254090 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4