my ($count) = $dbh->selectrow_array($sql); # or if you substitute '$data[\d+]' with ? in your sql my ($count) = $dbh->selectrow_array($sql, {}, @data);