Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things

Re: use of DBI perl function fetchall_arrayref

by imp (Priest)
on Jan 25, 2007 at 22:18 UTC ( #596641=note: print w/replies, xml ) Need Help??

in reply to use of DBI perl function fetchall_arrayref

You were close.
# Create an anonymous arrayref my $arrayref = [1,2,3]; # Create a reference to an existing array my @array = (1,2,3); my $arrayref2 = \@array; # Get a single value from the arrayref: my $one = $arrayref2->[0]; # Get all the values from the arrayref: my ($one,$two,$three) = @$arrayref2;
In the code you posted you wrote:
Which is putting the arrayref provided by DBI inside another arrayref. Instead do this:
It might help you visualize the data structure if you use Data::Dumper, like this:
use Data::Dumper; #... my $sql_return = $sth_tss->fetchall_arrayref; print Dumper $sql_return;

Replies are listed 'Best First'.
Re^2: use of DBI perl function fetchall_arrayref
by EvanK (Chaplain) on Jan 26, 2007 at 15:24 UTC
    and if you want to be explicit in dereferencing, enclose the references in braces. this sometimes helps increase readability:
    # dereferencing an array print @$reference; # EXPLICITLY dereferencing an array print @{$reference};

    The trouble with having an open mind, of course, is that people will insist on coming along and trying to put things in it.
    - Terry Pratchett

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://596641]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (5)
As of 2016-10-22 04:43 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (292 votes). Check out past polls.