[Koha-cvs] koha/C4 Biblio.pm

[Robert Lyon]

CVSROOT:        /sources/koha
Module name:    koha
Changes by:     Robert Lyon <bob_lyon>  06/06/06 23:13:14

Modified files:
        C4             : Biblio.pm 

Log message:
        Merging katipo changes...
        
        altering subject search to stop returning blank rows

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/C4/Biblio.pm?cvsroot=koha&r1=1.171&r2=1.172

Patches:
Index: Biblio.pm
===================================================================
RCS file: /sources/koha/koha/C4/Biblio.pm,v
retrieving revision 1.171
retrieving revision 1.172
diff -u -b -r1.171 -r1.172
--- Biblio.pm   17 May 2006 16:06:24 -0000      1.171
+++ Biblio.pm   6 Jun 2006 23:13:14 -0000       1.172
@@ -33,7 +33,7 @@
 use vars qw($VERSION @ISA @EXPORT);
 
 # set the version for version checking
-$VERSION = do { my @v = '$Revision: 1.171 $' =~ /\d+/g;
+$VERSION = do { my @v = '$Revision: 1.172 $' =~ /\d+/g;
                 shift(@v) . "." . join("_", map {sprintf "%03d", $_ } @v); };
 
 @ISA = qw(Exporter);
@@ -2263,7 +2263,9 @@
        } # while
        $data->{subtitles} = address@hidden;
        $sth->finish;
-       $sth   = $dbh->prepare("Select * from bibliosubject where biblionumber 
= ?");
+       $sth   = $dbh->prepare("SELECT * FROM bibliosubject 
+                                WHERE subject != ''
+                                AND biblionumber = ?");
        $sth->execute($bibnum);
        my @subjects;
        while (my $dat = $sth->fetchrow_hashref){
@@ -3125,8 +3127,13 @@
 
 =cut
 
-# $Id: Biblio.pm,v 1.171 2006/05/17 16:06:24 plg Exp $
+# $Id: Biblio.pm,v 1.172 2006/06/06 23:13:14 bob_lyon Exp $
 # $Log: Biblio.pm,v $
+# Revision 1.172  2006/06/06 23:13:14  bob_lyon
+# Merging katipo changes...
+#
+# altering subject search to stop returning blank rows
+#
 # Revision 1.171  2006/05/17 16:06:24  plg
 # New feature from SAN Ouest Provence: ability to reserve a specific item in
 # the intranet. The development was made on branch 2.2 by Arnaud Laurin from