Re: Hash arrays

[Anonymous Monk]

Sure, provide some data in the form of perl variables, and I'll show you how to do it

[rkrish]

Here is the code and variables:

$stmnt = :"select acct_nbr,cycle_cd,cycle_end_dt from usage_rcvd" ;
$sth = dbh->prepare($stmt);

while ($sth->fetch())
{
bind_col(1,$acct_nbr);
bind_col(2,$cyc_cd);
bind_col(3,$cyc_end);

here I need to store them in hash array:
key is $acct_nbr
values are $cyc_cd and $cyc_end


}

[Anonymous Monk]

See DBI recipes

[Anonymous Monk]

Doesn't look very much like valid perl, sorry, all I can suggest for you is perlintro

[rkrish]

I'm yet to prepare,that is just code snippet to make you understand what i need to do:

$stmnt = :"select acct_nbr,cycle_cd,cycle_end_dt from usage_rcvd" ;
$sth = dbh->prepare($stmt);

while ($sth->fetch())
{
$sth->bind_col(1,$acct_nbr);
$sth->bind_col(2,$cyc_cd);
$sth->bind_col(3,$cyc_end);

here I need to store them in hash array:
key is $acct_nbr
values are $cyc_cd and $cyc_end


}