From b65bd46a6bf2a5d957c7d768c5ee597897c3bc4c Mon Sep 17 00:00:00 2001 From: wolfpac444 Date: Mon, 5 May 2003 11:51:20 +0000 Subject: [PATCH] *** empty log message *** --- C4/Reserves2.pm | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/C4/Reserves2.pm b/C4/Reserves2.pm index 61dec7a934..f6e8c60140 100755 --- a/C4/Reserves2.pm +++ b/C4/Reserves2.pm @@ -527,15 +527,15 @@ sub Findgroupreserve { reserves.itemnumber AS itemnumber FROM reserves LEFT JOIN reserveconstraints ON reserves.biblionumber = reserveconstraints.biblionumber - WHERE reserves.biblionumber = $biblio - AND ( ( reserveconstraints.biblioitemnumber = $bibitem + WHERE reserves.biblionumber = ? + AND ( ( reserveconstraints.biblioitemnumber = ? AND reserves.borrowernumber = reserveconstraints.borrowernumber AND reserves.reservedate =reserveconstraints.reservedate ) OR reserves.constrainttype='a' ) AND reserves.cancellationdate is NULL AND (reserves.found <> 'F' or reserves.found is NULL)"; my $sth=$dbh->prepare($query); - $sth->execute; + $sth->execute($biblio, $bibitem); # FIXME - $i is unnecessary and bogus my $i=0; my @results; -- 2.39.5