Lines 91-97
sub search {
Link Here
|
91 |
$limit = "LIMIT $dt_params->{iDisplayStart},$dt_params->{iDisplayLength}"; |
91 |
$limit = "LIMIT $dt_params->{iDisplayStart},$dt_params->{iDisplayLength}"; |
92 |
} |
92 |
} |
93 |
|
93 |
|
94 |
my $query = join(" ", $select, $from, $where, $orderby, $limit); |
94 |
my $query = join( |
|
|
95 |
" ", |
96 |
($select ? $select : ""), |
97 |
($from ? $from : ""), |
98 |
($where ? $where : ""), |
99 |
($orderby ? $orderby : ""), |
100 |
($limit ? $limit : "") |
101 |
); |
95 |
my $sth = $dbh->prepare($query); |
102 |
my $sth = $dbh->prepare($query); |
96 |
$sth->execute(@where_args); |
103 |
$sth->execute(@where_args); |
97 |
my $patrons = $sth->fetchall_arrayref({}); |
104 |
my $patrons = $sth->fetchall_arrayref({}); |