It is an oracle database that I access throught DBI and DBD::oracle.
What I am trying to do is retrieve multiple records from the database for updating. I want the existing values in the database to be the default values in the respective textfields (and blank if the db value is null). I want to display the records in a table format so that each row is a different record, and each column is an attribute in the database.
The database contains (for example) the following fields: cd_vol_num, ship_date, tracking_num, notes.
If the user wants to update the notes of 10 cd's I want the form to print a table that has 10 rows and 4 columns.
The cd_vol_num is static so it is just text. The other fields can be updated so I want them to appear as textfields. I was trying to do this using an array of hashes.
If the 4th cd in the series already has notes I want those be the default value for that cell. So that they appear when the page is rendered. This way the user can append to the notes or remove the previous note. I need the form to only have one submit button so that when pressed all the fields will be updated in the database

Thanks for taking a look at this.
JLD

In reply to Re: Re: muli-records db update using cgi by dean0308
in thread multi-record db update using cgi by dean0308

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.