[Koha-cvs] koha/C4 Search.pm [rel_3_0]

[Antoine Farnault]

CVSROOT:        /sources/koha
Module name:    koha
Branch:         rel_3_0
Changes by:     Antoine Farnault <toins>        06/10/23 10:12:51

Modified files:
        C4             : Search.pm 

Log message:
        back to the previous SQL query.. It works only with mysql4.1...

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/C4/Search.pm?cvsroot=koha&only_with_tag=rel_3_0&r1=1.120.2.13&r2=1.120.2.14

Patches:
Index: Search.pm
===================================================================
RCS file: /sources/koha/koha/C4/Search.pm,v
retrieving revision 1.120.2.13
retrieving revision 1.120.2.14
diff -u -b -r1.120.2.13 -r1.120.2.14
--- Search.pm   23 Oct 2006 09:09:52 -0000      1.120.2.13
+++ Search.pm   23 Oct 2006 10:12:51 -0000      1.120.2.14
@@ -40,7 +40,7 @@
 use vars qw($VERSION @ISA @EXPORT @EXPORT_OK %EXPORT_TAGS);
 
 # set the version for version checking
-$VERSION = do { my @v = '$Revision: 1.120.2.13 $' =~ /\d+/g;
+$VERSION = do { my @v = '$Revision: 1.120.2.14 $' =~ /\d+/g;
           shift(@v) . "." . join("_", map {sprintf "%03d", $_ } @v); };
 
 =head1 NAME
@@ -1431,14 +1431,18 @@
 #'
 sub bibdata {
        my ($bibnum, $type) = @_;
-       
        my $dbh   = C4::Context->dbh;
-       my $sth   = $dbh->prepare("Select *, biblioitems.notes AS bnotes, 
biblio.notes
-                                                               from biblio, 
biblioitems
-                                                               left join 
bibliosubtitle USING (biblionumber)
-                                                               left join 
itemtypes USING (itemtype)
-                                                               where 
biblio.biblionumber = ?
-                                                               and 
biblioitems.biblionumber = biblio.biblionumber");
+       my $query = "
+           SELECT *, biblioitems.notes AS bnotes, biblio.notes
+               FROM   biblio, biblioitems
+                   LEFT JOIN bibliosubtitle ON
+                           biblio.biblionumber = bibliosubtitle.biblionumber
+                       LEFT JOIN itemtypes ON
+                           biblioitems.itemtype=itemtypes.itemtype
+               WHERE  biblio.biblionumber = ?
+                   AND biblioitems.biblionumber = biblio.biblionumber
+       ";
+       my $sth   = $dbh->prepare($query);
        $sth->execute($bibnum);
        my $data;
        $data  = $sth->fetchrow_hashref;