Solved

array of hashes

Posted on 2002-07-22
2
238 Views
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?
Thanks
0
Comment
Question by:hank1
2 Comments
 
LVL 1

Author Comment

by:hank1
ID: 7170715
Whoops.  Don't post here.  DELETE
Sorry guys.
0
 
LVL 6

Accepted Solution

by:
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";
   };
};
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

I have been pestered over the years to produce and distribute regular data extracts, and often the request have explicitly requested the data be emailed as an Excel attachement; specifically Excel, as it appears: CSV files confuse (no Red or Green h…
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…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

776 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