my %attr = ( dbi_fetchall_arrayref_attr => {}, ); my $statement = q{ SELECT * FROM table WHERE field LIKE ? }; $template->param( rows => $dbh->selectall_arrayref($statement, \%attr, $value), );