$employer = $query->param('employer'); my $query2 = qq{ select id, name, salary from employees where employer = ? }; my $employees_loh = $dbh->selectall_arrayref($query2, {Slice => {}});