From ead92228f02ce084aca4cd31bea13f4dfc157600 Mon Sep 17 00:00:00 2001 From: rangi Date: Wed, 12 Jul 2006 09:15:26 +0000 Subject: [PATCH] Fixing bad sql --- C4/Circulation/Fines.pm | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) diff --git a/C4/Circulation/Fines.pm b/C4/Circulation/Fines.pm index b065cba7bc..c2b0f7b242 100644 --- a/C4/Circulation/Fines.pm +++ b/C4/Circulation/Fines.pm @@ -155,11 +155,12 @@ sub CalcFine { # categoryitem table. my $sth = $dbh->prepare( -"Select * from items,biblioitems,itemtypes,issuingrules where items.itemnumber=? - and items.biblioitemnumber=biblioitems.biblioitemnumber and - biblioitems.itemtype=itemtypes.itemtype and - categoryitem.itemtype=itemtypes.itemtype and - categoryitem.categorycode=? and (items.itemlost <> 1 or items.itemlost is NULL)" +"SELECT * FROM items,biblioitems,itemtypes,issuingrules + WHERE items.itemnumber=? + AND items.biblioitemnumber=biblioitems.biblioitemnumber + AND biblioitems.itemtype=itemtypes.itemtype + AND issuingrules.itemtype=itemtypes.itemtype + AND issuingrules.categorycode=? AND (items.itemlost <> 1 OR items.itemlost is NULL)" ); # print $query; -- 2.39.5