Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: OT: updating database question

by revdiablo (Prior)
on Jul 22, 2007 at 07:58 UTC ( [id://628095]=note: print w/replies, xml ) Need Help??


in reply to OT: updating database question

I'd opt for another approach than the two you outlined. I would change the form to submit imperative commands that match what the user actually did, rather than a copy of what the end result should be.

By way of example, if you want to remove Alice's MA, you check a "delete this qualification" box. Your form is then telling the handler that you want to delete the MA, and you don't have to do a tedious backend comparison, nor the expensive rebuild everything from scratch.

Replies are listed 'Best First'.
Re^2: OT: updating database question
by apl (Monsignor) on Jul 22, 2007 at 12:37 UTC
    This also has the added benefit of differentiating why the delete took place. At some point in the future, the user may require an audit trail and will want to know that a new degree was added or that a mistake was corrected.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://628095]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others pondering the Monastery: (4)
As of 2024-03-28 17:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found