Re^2: Hash arrays

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


}
[download]

Comment on Re^2: Hash arrays Download Code

Replies are listed 'Best First'.
Re^3: Hash arrays by Anonymous Monk on Dec 26, 2012 at 10:00 UTC
See DBI recipes	[reply]
Re^3: Hash arrays by Anonymous Monk on Dec 26, 2012 at 09:59 UTC
Doesn't look very much like valid perl, sorry, all I can suggest for you is perlintro	[reply]
Re^4: Hash arrays by rkrish (Acolyte) on Dec 26, 2012 at 10:09 UTC
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 }` [download]	[reply] [d/l]
Re^5: Hash arrays by AnomalousMonk (Archbishop) on Dec 26, 2012 at 12:22 UTC
Can you say whether and how the reply of 2teez does not address your questions? (Please do not repeat the OPed pseudo-code snippet again.)	[reply]