### Re: Re: DBI specification change

by aufrank (Pilgrim)
 on Jul 18, 2002 at 16:06 UTC ( #182879=note: print w/replies, xml ) Need Help??

in reply to Re: DBI specification change

this actually already exists and is very useful. the method you're looking for is fetchall_arrayref( {} )

from the docs:

"When passed a hash reference, fetchall_arrayref uses /fetchrow_hashref to fetch each row as a hash reference. If the parameter hash is empty then fetchrow_hashref is simply called in a tight loop and the keys in the hashes have whatever name lettercase is returned by default from fetchrow_hashref."
and
"To fetch all fields of every row as a hash ref:
$tbl_ary_ref =$sth->fetchall_arrayref({});  "

going through each row then looks something like:

foreach my $hashref_row (@$tbl_ary_ref) {
foreach my $field (sort keys %$hashref_row) {
my $value =$hashref_row->{\$field};
}
}
[download]

there's a good chance my use of references is off in the 3rd line, but at least I tried :)

hope that's what you were looking for!
--au

Create A New User
Node Status?
node history
Node Type: note [id://182879]
help
Chatterbox?
 [thezip]: Is there an analogy for '&' (ie. run commandline process in background) for Windows commandline? [Corion]: thezip: start "some title" path\to\that\ application, but that will open another console window [Corion]: thezip: If you want to confuse your users, use system(1, "that\\command" );, which will make Perl launch it in the background [Corion]: That will keep the console window open even though the user can't type into it anymore [thezip]: So I have a script that generates a log file. After script completion, I want tohave VIM open this logfile. [thezip]: i don't get the command line "back" until I close VIM. No what I want to happen...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (14)
As of 2017-03-27 18:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
Voting Booth?
Should Pluto Get Its Planethood Back?

Results (321 votes). Check out past polls.