array of hashes

Posted on 2002-07-22
Last Modified: 2010-08-05
Have a hash (from ODBC $db->DataHash) and
want to place it into an array of hashes.  How?

while ($db->FetchRow()) {
   undef %Data;
   %Data = $db->DataHash();
   # concept  push @a, %Data;  # Yes, I know this doesn't come close.

Do I have to break up %Data into its key/value pair and

push @a, {key1 => value, key2 => value}

or is there a better way?
Question by:hank1

Author Comment

ID: 7170715
Whoops.  Don't post here.  DELETE
Sorry guys.

Accepted Solution

sstouk earned 50 total points
ID: 7178661
Try this:

while ($db->FetchRow()) {
  undef %Data;
  %Data = $db->DataHash();
push @HArray, \%Data;
  # concept  push @a, %Data;  # Yes, I know this doesn't come close.

To get it back:

foreach $ArrElem (@HArray)
%HashBack = %$ArrElem;
 foreach $key (keys %HashBack)
    print "$key and $HashBack{$key}\n";

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
delete query using perl dbi 3 109
Perl Sort Question 4 141
what are these modules in perl script 4 103
Able to retrieve only 1 row through email amongst multiple rows 3 57
A year or so back I was asked to have a play with MongoDB; within half an hour I had downloaded (,  installed and started the daemon, and had a console window open. After an hour or two of playing at the command …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question