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