View | Details | Raw Unified | Return to bug 9811
Collapse All | Expand All

(-)a/C4/Utils/DataTables/Members.pm (-3 / +2 lines)
Lines 104-116 sub search { Link Here
104
    my $patrons = $sth->fetchall_arrayref({});
104
    my $patrons = $sth->fetchall_arrayref({});
105
105
106
    # Get the iTotalDisplayRecords DataTable variable
106
    # Get the iTotalDisplayRecords DataTable variable
107
    $query = "SELECT COUNT(*) " . $from . ($where ? $where : "");
107
    $query = "SELECT COUNT(borrowers.borrowernumber) " . $from . ($where ? $where : "");
108
    $sth = $dbh->prepare($query);
108
    $sth = $dbh->prepare($query);
109
    $sth->execute(@where_args);
109
    $sth->execute(@where_args);
110
    ($iTotalDisplayRecords) = $sth->fetchrow_array;
110
    ($iTotalDisplayRecords) = $sth->fetchrow_array;
111
111
112
    # Get the iTotalRecords DataTable variable
112
    # Get the iTotalRecords DataTable variable
113
    $query = "SELECT COUNT(*) FROM borrowers";
113
    $query = "SELECT COUNT(borrowers.borrowernumber) FROM borrowers";
114
    $sth = $dbh->prepare($query);
114
    $sth = $dbh->prepare($query);
115
    $sth->execute;
115
    $sth->execute;
116
    ($iTotalRecords) = $sth->fetchrow_array;
116
    ($iTotalRecords) = $sth->fetchrow_array;
117
- 

Return to bug 9811