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

[Joshua Ferraro]

CVSROOT:	/sources/koha
Module name:	koha
Branch:		dev_week
Changes by:	Joshua Ferraro <kados>	06/10/04 02:19:18

Modified files:
	C4             : Search.pm 

Log message:
	looking for itemtypes.notforloan, not items.notforloan (we get that
	automatically with the *)

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/C4/Search.pm?cvsroot=koha&only_with_tag=dev_week&r1=1.99.2.11.2.26&r2=1.99.2.11.2.27

Patches:
Index: Search.pm
===================================================================
RCS file: /sources/koha/koha/C4/Search.pm,v
retrieving revision 1.99.2.11.2.26
retrieving revision 1.99.2.11.2.27
diff -u -b -r1.99.2.11.2.26 -r1.99.2.11.2.27
--- Search.pm	29 Sep 2006 16:07:47 -0000	1.99.2.11.2.26
+++ Search.pm	4 Oct 2006 02:19:18 -0000	1.99.2.11.2.27
@@ -39,7 +39,7 @@
 use vars qw($VERSION @ISA @EXPORT @EXPORT_OK %EXPORT_TAGS);
 
 # set the version for version checking
-$VERSION = do { my @v = '$Revision: 1.99.2.11.2.26 $' =~ /\d+/g;
+$VERSION = do { my @v = '$Revision: 1.99.2.11.2.27 $' =~ /\d+/g;
           shift(@v) . "." . join("_", map {sprintf "%03d", $_ } @v); };
 
 =head1 NAME
@@ -1241,12 +1241,12 @@
 sub ItemInfo {
 	my ($env,$biblionumber,$type) = @_;
 	my $dbh   = C4::Context->dbh;
-	my $query = "SELECT *,items.notforloan as itemnotforloan FROM items, biblio, biblioitems 
-					left join itemtypes on biblioitems.itemtype = itemtypes.itemtype
+	my $query = "SELECT *,itemtypes.notforloan AS itemnotforloan FROM items, biblio, biblioitems 
+					LEFT JOIN itemtypes ON biblioitems.itemtype = itemtypes.itemtype
 					WHERE items.biblionumber = ?
 					AND biblioitems.biblioitemnumber = items.biblioitemnumber
 					AND biblio.biblionumber = items.biblionumber";
-	$query .= " order by items.dateaccessioned desc";
+	$query .= " ORDER BY items.dateaccessioned DESC";
 	my $sth=$dbh->prepare($query);
 	$sth->execute($biblionumber);
 	my $i=0;