fetchall_arrayref returns an arrayref. And there's not much point in returning references to scalars here. So change get_db_entries' return to:

return($aoa,$nrows,$nfields);

[download]

Then your main routine could say something like:

print "\nnrows: $bighash{$day}{nrows}\n";
print "\nnfields: $bighash{$day}{nfields}\n";
print "aoa:  $bighash{$day}{aoa}[$i][2] after\n";

[download]

It's the $aoa in $bighash{$day}->$aoa->[$i]->[2] that's causing the 'uninitialized value in method lookup' etc. errors.

It's $aoa instead of just aoa in your assignment in the foreach day loop that's causing the other error.

Finding these sorts of things is exactly why people advise including 'use warnings' so much.

Also, since your bighash is indexed by the digits 0-6, you could use a bigarray instead.

Updated: Explained better the causes of the stated problems.

In reply to Re: Passing Array of Array refs as a reference by Zed_Lopez
in thread Passing Array of Array refs as a reference by tdp05

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.