[Koha-cvs] koha/C4 SearchMarc.pm [rel_2_2]

[Henri-Damien LAURENT]

CVSROOT:        /sources/koha
Module name:    koha
Branch:         rel_2_2
Changes by:     Henri-Damien LAURENT <hdl>      07/07/16 15:23:18

Modified files:
        C4             : SearchMarc.pm 

Log message:
        Bug Fixing... Search in blob fields too.

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/C4/SearchMarc.pm?cvsroot=koha&only_with_tag=rel_2_2&r1=1.36.2.39&r2=1.36.2.40

Patches:
Index: SearchMarc.pm
===================================================================
RCS file: /sources/koha/koha/C4/Attic/SearchMarc.pm,v
retrieving revision 1.36.2.39
retrieving revision 1.36.2.40
diff -u -b -r1.36.2.39 -r1.36.2.40
--- SearchMarc.pm       28 Feb 2007 09:18:26 -0000      1.36.2.39
+++ SearchMarc.pm       16 Jul 2007 15:23:18 -0000      1.36.2.40
@@ -613,7 +613,7 @@
                $maxtag = "399";
        }
 
-       my $sth=$dbh->prepare("SELECT subfieldvalue,tag FROM 
marc_subfield_table WHERE bibid=? AND tag BETWEEN ? AND ? ORDER BY tagorder");
+       my $sth=$dbh->prepare("SELECT IF(m2.blobidlink IS NOT 
NULL,m2.subfieldvalue,m1.subfieldvalue),tag FROM marc_subfield_table m1 LEFT 
JOIN marc_blob_subfield m2 on m1.valuebloblink=m2.blobidlink WHERE bibid=? AND 
tag BETWEEN ? AND ? ORDER BY tagorder");
 
        $sth->execute($bibid,$mintag,$maxtag);