|
Lines 123-130
sub OldWay {
Link Here
|
| 123 |
$query .= 'WHERE '; |
123 |
$query .= 'WHERE '; |
| 124 |
$query .= join ' AND ', @where_strings; |
124 |
$query .= join ' AND ', @where_strings; |
| 125 |
} |
125 |
} |
| 126 |
$query .= ' ORDER BY items.cn_sort, itemcallnumber, title'; |
|
|
| 127 |
my $count_query = $select_count . $query; |
126 |
my $count_query = $select_count . $query; |
|
|
127 |
$query .= ' ORDER BY items.cn_sort, itemcallnumber, title'; |
| 128 |
$query .= " LIMIT $offset, $size" if ($offset and $size); |
128 |
$query .= " LIMIT $offset, $size" if ($offset and $size); |
| 129 |
$query = $select_columns . $query; |
129 |
$query = $select_columns . $query; |
| 130 |
my $sth = $ldbh->prepare($query); |
130 |
my $sth = $ldbh->prepare($query); |
| 131 |
- |
|
|