RE: dbi selectall_hashref drops results

2015-05-15 Thread Kyle A. Hamilton
There's the issue. I was using a primary key from the database as the hash key so I assumed there were no duplicates. Just did a manual query and there are duplicate ids, must be my query or the database. Thank you! -Original Message- From: Martin J. Evans [mailto:boh...@ntlworld.com]

Re: dbi selectall_hashref drops results

2015-05-15 Thread Martin J. Evans
On 15/05/15 15:56, Kyle A. Hamilton wrote: I ran into an issue where dbi’s selectall_hashref will drop results returned from the database. If I change the query to count the number of results returned, it returns 96, but I am missing some records that I get when I manually query the database. If

dbi selectall_hashref drops results

2015-05-15 Thread Kyle A. Hamilton
I ran into an issue where dbi’s selectall_hashref will drop results returned from the database. If I change the query to count the number of results returned, it returns 96, but I am missing some records that I get when I manually query the database. If I use selectall_array ref and loop through