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 |
- |
|
|