in reply to can't locate object method

it means you have typo:

# both of these... $dbh->selectcol_arraryref $dbh->selectcol_arraryfef # should be: $dbh->selectcol_arrayref