From 2de821976909be70e3ea964df1aeec492b4e3f08 Mon Sep 17 00:00:00 2001 From: kados Date: Tue, 7 Feb 2006 23:19:09 +0000 Subject: [PATCH] Fixing a bug in the query --- overdue.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/overdue.pl b/overdue.pl index 92c64d5119..f82387e17c 100755 --- a/overdue.pl +++ b/overdue.pl @@ -123,7 +123,7 @@ $bornamefilter =~s/\?/\_/g; my $strsth="select date_due,concat(firstname,' ',surname) as borrower, borrowers.phone, borrowers.emailaddress,issues.itemnumber, biblio.title, biblio.author from issues, borrowers,items,biblioitems, biblio where isnull(returndate) "; $strsth.= " && date_due<'".$todaysdate."' " unless ($showall); -$strsth.= " && issues.borrowernumber=borrowers.borrowernumber && issues.itemnumber=items.itemnumber && biblioitems.biblioitemnumber=items.itemnumber && biblio.biblionumber=items.biblionumber "; +$strsth.= " && issues.borrowernumber=borrowers.borrowernumber && issues.itemnumber=items.itemnumber && biblioitems.biblioitemnumber=items.biblioitemnumber && biblio.biblionumber=items.biblionumber "; $strsth.=" && (borrowers.firstname like '".$bornamefilter."%' or borrowers.surname like '".$bornamefilter."%' or borrowers.cardnumber like '".$bornamefilter."%')" if($bornamefilter) ; $strsth.=" && borrowers.categorycode = '".$borcatfilter."' " if($borcatfilter) ; $strsth.=" && biblioitems.itemtype = '".$itemtypefilter."' " if($itemtypefilter) ; -- 2.39.5