and don't forget to set RaiseError or check $sth->err afterwards because if fetchrow_arrayref fails it can still return rows. See http://search.cpan.org/~timb/DBI-1.607/DBI.pm#fetchall_arrayref