From 904193007766b8903c57b1c2a78812e8d57e3bd9 Mon Sep 17 00:00:00 2001 From: Ryan Higgins Date: Wed, 8 Oct 2008 00:31:24 -0500 Subject: [PATCH] Remove ambiguity from SQL statement for holds queue. holdingbranch table not referenced in view_holdsqueue.pl, causing irresolvable ambiguity in sql query when limited by library (holdingbranch). This was causing DBI errors to be thrown in test database, and library-limited holdsqueue display was thus empty. Signed-off-by: Galen Charlton --- circ/view_holdsqueue.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/circ/view_holdsqueue.pl b/circ/view_holdsqueue.pl index a52400bdd8..e8e47a6328 100755 --- a/circ/view_holdsqueue.pl +++ b/circ/view_holdsqueue.pl @@ -101,7 +101,7 @@ sub GetHoldsQueueItems { LEFT JOIN items USING (itemnumber) /; if ($branchlimit) { - $query .=" WHERE holdingbranch = ?"; + $query .=" WHERE tmp_holdsqueue.holdingbranch = ?"; push @bind_params, $branchlimit; } $query .= " ORDER BY ccode, location, cn_sort, author, title, pickbranch, reservedate"; -- 2.39.2