Updating one column verses 10 or even 50 wont make much difference PLUS this is done on the DB server, so CF just passes this on (if it's on 2 different servers). You wont see a performance increase from updating only a few columns. If you wanted the colors thingy.. you could use a Confirm page.. have the update page post data to a confirm page "Are you sure you want to overwrite these variables", or whatever. There you could actually check the form data against the DB data... But anyways, yeah if you wanted it on fly, you'd have to use JS or some client side language to change the colors.
On 9/25/06, Teddy Payne <[EMAIL PROTECTED]> wrote: > The red and green aspect would probably be faciliated by client side > scripting like Javascript to change the colors of the data fields as they > are modified. OnChange event should handle those just fine. > > Are you opposed to querying the database for a complete recordset? What I > mean by this, you can load the record in action page and then compare > against the variables in the form scope. Once you compare the fields that > have changes, you can create a structure to store the names of the column > and the data to be updated. After you create the structure, loop over the > structure inside of cfquery statement with the column names in insert into > tableName () area and the values in the values() area. > > Does that make sense? > > Teddy > > On 9/25/06, Richard White <[EMAIL PROTECTED]> wrote: > > > > 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:254092 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
