in reply to DBI selectall_arrayref

Please try with the below it is working for me

@values = map( { $_->[0] } @{ $dbh->selectall_arrayref($sql) } );

Please provide