From 772d5bc36cffba34d78ef75691d52d2bee2ce273 Mon Sep 17 00:00:00 2001 From: finlayt Date: Thu, 3 Oct 2002 03:56:10 +0000 Subject: [PATCH] Added a field to the barcodes sql search, now it returns the holding branch as well. --- C4/Search.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Search.pm b/C4/Search.pm index 642d6abf4e..1e14d2021c 100755 --- a/C4/Search.pm +++ b/C4/Search.pm @@ -2306,7 +2306,7 @@ sub barcodes{ #called from request.pl my ($biblioitemnumber)=@_; my $dbh=C4Connect; - my $query="SELECT barcode, itemlost FROM items + my $query="SELECT barcode, itemlost, holdingbranch FROM items WHERE biblioitemnumber = ? AND (wthdrawn <> 1 OR wthdrawn IS NULL)"; my $sth=$dbh->prepare($query); -- 2.39.5