@@ -, +, @@ --- C4/Utils/DataTables/Members.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) --- a/C4/Utils/DataTables/Members.pm +++ a/C4/Utils/DataTables/Members.pm @@ -104,13 +104,13 @@ sub search { my $patrons = $sth->fetchall_arrayref({}); # Get the iTotalDisplayRecords DataTable variable - $query = "SELECT COUNT(*) " . $from . ($where ? $where : ""); + $query = "SELECT COUNT(borrowers.borrowernumber) " . $from . ($where ? $where : ""); $sth = $dbh->prepare($query); $sth->execute(@where_args); ($iTotalDisplayRecords) = $sth->fetchrow_array; # Get the iTotalRecords DataTable variable - $query = "SELECT COUNT(*) FROM borrowers"; + $query = "SELECT COUNT(borrowers.borrowernumber) FROM borrowers"; $sth = $dbh->prepare($query); $sth->execute; ($iTotalRecords) = $sth->fetchrow_array; --