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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to strip .csv from file name 9 78
unable to remove invisible characters with perl 2 77
problem with using the glob function 1 63
Insert Text into odbc.ini file 15 64
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 …
In the distant past (last year) I hacked together a little toy that would allow a couple of Manager types to query, preview, and extract data from a number of MongoDB instances, to their tool of choice: Excel (…
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…
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

930 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now