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