[Koha-cvs] koha/C4 SearchMarc.pm [R_2-2-7-1]

[Antoine Farnault]

CVSROOT:        /sources/koha
Module name:    koha
Branch:         R_2-2-7-1
Changes by:     Antoine Farnault <toins>        07/02/12 10:39:12

Modified files:
        C4             : SearchMarc.pm 

Log message:
        Commiting BUG FIX for 2.2.7.1.
        
        (mysql 5 syntax changes)

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/C4/SearchMarc.pm?cvsroot=koha&only_with_tag=R_2-2-7-1&r1=1.36.2.35&r2=1.36.2.35.2.1

Patches:
Index: SearchMarc.pm
===================================================================
RCS file: /sources/koha/koha/C4/Attic/SearchMarc.pm,v
retrieving revision 1.36.2.35
retrieving revision 1.36.2.35.2.1
diff -u -b -r1.36.2.35 -r1.36.2.35.2.1
--- SearchMarc.pm       3 Nov 2006 10:59:51 -0000       1.36.2.35
+++ SearchMarc.pm       12 Feb 2007 10:39:12 -0000      1.36.2.35.2.1
@@ -381,9 +381,9 @@
        # HINT : biblionumber as bn is important. The hash is fills 
biblionumber with items.biblionumber.
        # so if you dont' has an item, you get a not nice empty value.
        $sth = $dbh->prepare("SELECT biblio.biblionumber as 
bn,biblioitems.*,biblio.*, 
marc_biblio.bibid,itemtypes.notforloan,itemtypes.description
-                                                       FROM biblio, 
marc_biblio 
-                                                       LEFT JOIN biblioitems 
on biblio.biblionumber = biblioitems.biblionumber
-                                                       LEFT JOIN itemtypes on 
itemtypes.itemtype=biblioitems.itemtype
+                                                       FROM  marc_biblio , 
biblio
+                                                       LEFT JOIN biblioitems 
on ( biblio.biblionumber = biblioitems.biblionumber )
+                                                       LEFT JOIN itemtypes on 
(itemtypes.itemtype=biblioitems.itemtype)
                                                        WHERE 
biblio.biblionumber = marc_biblio.biblionumber AND bibid = ?");
         my $sth_subtitle = $dbh->prepare("SELECT subtitle FROM bibliosubtitle 
WHERE biblionumber=?"); # Added BY JF for Subtitles
        my @finalresult = ();