Best solution to prevent unwanted database updates
srikanth bukkapatnam
Greenhorn
Joined: Jul 31, 2001
Posts: 7
posted
0
When a user clicks submit on a page, when nothing has changed,what would be the best and efficient solution to check for real updates. - things to consider: Business objects in question are really large and spans multiple tables, so saving previous object in session is ruled out. Column to Column check for changes before update is also ruled out. -cannot use triggers on tables Any solution that does a check on Html Page level for something that has changed is acceptable. Thanks in advance, Srikanth
Robert Brunner
Ranch Hand
Joined: Jul 18, 2001
Posts: 49
posted
0
If the user is using GET/POST to update form fields, you have access to all of the data at the server, just check to see if anything was changed in the forms. You can do this simply with beans, but probably other ways as well.