Hello Monks,

I have dynamic webpage which on submit calls itself (a cgi script). There are multiple HTML text boxes on the form. On form submit all these form element names and their values (parameter names and values) are submitted to cgi script.

I can get this entire list of parameter name and values using $query->Dump; Any change in these parameters will have to be updated in DB so I am running DB queries for each of those parameters which results in many DB queries being fired and slowing down the response on webpage. I can't run all the updates in single query as well due to some business logic. So what I am thinking is to run the queries only for those elements/parameters that have been changed.

Is there any way to get list of only those parameters that have changed, so that I can run DB queries only for those parameters and not for all? Or any other better way to do it?

Please forgive me if the description doesn't make it clear but I tried my best and can answer any other specific question to make it clearer.

In reply to [Solved]: How to get only changed parameter names from CGI script on form submit? by Perl300

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.