|
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({}); |