[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;