my $statement = q{ SELECT * FROM BuyersSellers WHERE FileNumber = ? }; #force selectall_arrayref to return an arrayref of hashrefs my %attr = ( dbi_fetchall_arrayref_attr => {}, ); my $BuyersSellers = $dbh->selectall_arrayref($statement, \%attr, $filenumber);