|Syntactic Confectionery Delight|
MySQL and Perl CGIby PyrexKidd (Monk)
|on May 14, 2011 at 20:13 UTC||Need Help??|
PyrexKidd has asked for the
wisdom of the Perl Monks concerning the following question:
I am working on an application that is a Perl CGI front end to a database. Essentially what I am doing is querying the DB to generate a table in the web page. I would like to be able to edit the DB fields directly from the web page. i.e. I have a table:
I would like to be able to click then name to change it, then submit the changes to the db.
My first thought was to cache the initial query results, cache the 'updated' changes, compare them, and dynamically create an UPDATE query. In practice this is not... a good way to do this.
Can any one recommend a good strategy to acheive the desired results?
thanks in advance for an assistance.