Help for this page

Select Code to Download


  1. or download this
    my $stmt = "SELECT firstname, lastname, city, state FROM addresses ORD
+ER BY lastname";
my $data = $self->dbh->selectall_arrayref($stmt, {Slice => {}});
  2. or download this
    [
    {
...
        'city'      => 'Miami'
    }
];
  3. or download this
    
[
...
        'state'     => 'FL'
    }
];
  4. or download this
    use Tie::IxHash;
my $data = {};
...
my $stmt = "SELECT firstname, lastname, city, state FROM addresses ORD
+ER BY lastname";
$data = $self->dbh->selectall_arrayref($stmt, {Slice => {}});