[Koha-cvs] CVS: koha/C4 Bull.pm,1.7,1.8

[doXulting]

Update of /cvsroot/koha/koha/C4
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv26731/C4

Modified Files:
	Bull.pm 
Log Message:
The search query was returning all records when  was empty

Index: Bull.pm
===================================================================
RCS file: /cvsroot/koha/koha/C4/Bull.pm,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -r1.7 -r1.8
*** Bull.pm	1 Mar 2005 13:40:48 -0000	1.7
--- Bull.pm	15 Apr 2005 14:31:51 -0000	1.8
***************
*** 229,234 ****
  		$sth->execute($biblionumber);
  	} else {
! 		$sth = $dbh->prepare("select subscription.subscriptionid,biblio.title,biblioitems.issn,subscription.notes from subscription,biblio,biblioitems where  biblio.biblionumber = biblioitems.biblionumber and biblio.biblionumber=subscription.biblionumber and (biblio.title like ? or biblioitems.issn = ? )");
! 		$sth->execute("%$title%",$ISSN);
  	}
  		my @results;
--- 229,251 ----
  		$sth->execute($biblionumber);
  	} else {
! 		if ($ISSN and $title)
! 		{
! 			$sth = $dbh->prepare("select subscription.subscriptionid,biblio.title,biblioitems.issn,subscription.notes from subscription,biblio,biblioitems where  biblio.biblionumber = biblioitems.biblionumber and biblio.biblionumber=subscription.biblionumber and (biblio.title like ? or biblioitems.issn = ? )");
! 			$sth->execute("%$title%",$ISSN);
! 		}
! 		else
! 		{
! 			if ($ISSN)
! 			{
! 				$sth = $dbh->prepare("select subscription.subscriptionid,biblio.title,biblioitems.issn,subscription.notes from subscription,biblio,biblioitems where  biblio.biblionumber = biblioitems.biblionumber and biblio.biblionumber=subscription.biblionumber and biblioitems.issn = ?");
! 				$sth->execute($ISSN);
! 			}
! 			else
! 			{
! 				$sth = $dbh->prepare("select subscription.subscriptionid,biblio.title,biblioitems.issn,subscription.notes from subscription,biblio,biblioitems where  biblio.biblionumber = biblioitems.biblionumber and
!  biblio.biblionumber=subscription.biblionumber and biblio.title like ? ");
! 				$sth->execute("%$title%");
! 			}
! 		}
  	}
  		my @results;