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