Update Record on changed fields
Posted on 2003-11-18
What/how is the best way of only saving changed fields to a record in a DB.
I am using Access/ASP.
I thought of doing it this way:-
<input type=text name=Firstname>
<input type=hidden name=FirstnameH>
<input type=text name=Lastname>
<input type=hidden name=LastnameH>
Then when I submit the form I use ASP to compare the Firstname & FirstnameH and only comit the field to the DB if they don't match. etc etc