I am certainly not a DB guy, but I think you have the wrong type of query. I would think that fetching rows from the DB makes more sense. This row that you would get from the DB will be in a fixed order. Using hash slice, you can make a hash and push it onto an array.

So maybe the first place to start is with these 11 fields. I couldn't figure out the DB names for all of these so, I just put x,y,z. If you could fill-in the second column below, that would be most helpful.

JP-AP1-1-RM_210,    xxxxx
Johanna Perrin,     yyyyy
wism3-1,            zzzzz
10.137.139.2,
wism4-1,
10.137.139.6,
wism7-1,
10.137.139.10,
JP,
149,
not_configured

[download]
The basic idea is to get a row from the DB, then make a %hash from that row (with the keys being x,y,z above) and then push a ref to that hash onto an array.

You will wind up with a memory structure with same info as in the DB. The order of the records within the structure will not correlate to any kind of order within the DB (I guess you know that).

In reply to Re^5: Hash throws out duplicate values by Marshall
in thread Hash throws out duplicate values by spickles

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.