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