[Koha-cvs] CVS: koha/C4 Acquisition.pm,1.9.2.3,1.9.2.4

[Paul POULAIN]

Update of /cvsroot/koha/koha/C4
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9430/C4

Modified Files:
      Tag: rel_2_2
        Acquisition.pm 
Log Message:
specifying table order to have aqorders.notes and not biblio.notes in {notes} 
field

Index: Acquisition.pm
===================================================================
RCS file: /cvsroot/koha/koha/C4/Acquisition.pm,v
retrieving revision 1.9.2.3
retrieving revision 1.9.2.4
diff -C2 -r1.9.2.3 -r1.9.2.4
*** Acquisition.pm      26 May 2005 09:21:29 -0000      1.9.2.3
--- Acquisition.pm      6 Jun 2005 16:36:43 -0000       1.9.2.4
***************
*** 563,567 ****
        map { push(@searchterms,"$_%","% $_%") } @data;
        push(@searchterms,$search,$search,$biblio);
!       my $sth=$dbh->prepare("Select *,biblio.title from 
aqorders,biblioitems,biblio,aqbasket
                where aqorders.biblioitemnumber = biblioitems.biblioitemnumber 
and
                aqorders.basketno = aqbasket.basketno
--- 563,567 ----
        map { push(@searchterms,"$_%","% $_%") } @data;
        push(@searchterms,$search,$search,$biblio);
!       my $sth=$dbh->prepare("Select 
biblio.*,biblioitems.*,aqorders.*,aqbasket.*,biblio.title from 
aqorders,biblioitems,biblio,aqbasket
                where aqorders.biblioitemnumber = biblioitems.biblioitemnumber 
and
                aqorders.basketno = aqbasket.basketno