Here is a short description of the issue:
I am to make a cgi script that accepts 'orders'. These orders consist of a record that describes the general order information (ship_to's, bill_to's, etc...) and a varaible number or 'lines' that describe the actual pieces that make up the order.

OK, so far so good with the general order information. The problem I have is deciding the best way to handle the variable number of lines. Below is a list of my possible solutions, please advise which is best (experienced opinions are my favorite) or give solutions that I myself have not thought of.

It is also planned that in the future, the definition of which fields are required for an order and for each line can be loaded from a DB so that each 'client' can have their own checks and validation for their complete orders.

I can see pros/cons to each approach, but I have tried to leave most of my opinion out. I am here to learn from others, not to stand on a soap box. :-)

the_Don
...making offers others can't rufuse.


In reply to Handling Dynamic URL Parameters by the_Don

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.