Loading hash from DBI

[Scott Taylor]

Hello,

I have an SQL table with 2 fields, ID and Descr and I want to load these 
into an array and a hash.

First the array @SecID should be just the first field and then the hash 
%Sections should be ID=>Descr

All I get is garbage

This is the code that doesn't work, I know I'm missing something here, but 
not what:

$SQL = qq[Select * from T_Sec_ID];
$sth = $dbh->prepare($SQL);
$sth->execute;

my %Sections = $sth->fetchrow_hashref;
$sth->finish;

$SQL = qq[select secid from T_Sec_ID];
$sth = $dbh->prepare($SQL);
$sth->execute;

my @SecIDs = $sth->fetchrow_arrayref;
$sth->finish;

Here is the output, not what I want:
HASH(0x82c6388)
ARRAY(0x82c6370)

TIA.

Scott.


-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]