[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Koha-cvs] CVS: koha/C4 SearchMarc.pm,1.44,1.45
From: |
Henri-Damien LAURENT |
Subject: |
[Koha-cvs] CVS: koha/C4 SearchMarc.pm,1.44,1.45 |
Date: |
Wed, 15 Jun 2005 06:21:25 -0700 |
Update of /cvsroot/koha/koha/C4
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv31993/C4
Modified Files:
SearchMarc.pm
Log Message:
Deleting joined tables without condition.
Issues, reserves, items.
Major Bug fixed : Catalogsearch would work no more.
Index: SearchMarc.pm
===================================================================
RCS file: /cvsroot/koha/koha/C4/SearchMarc.pm,v
retrieving revision 1.44
retrieving revision 1.45
diff -C2 -r1.44 -r1.45
*** SearchMarc.pm 3 Jun 2005 03:58:26 -0000 1.44
--- SearchMarc.pm 15 Jun 2005 13:21:22 -0000 1.45
***************
*** 281,289 ****
my $sth;
if ($sql_where2) {
! $sth = $dbh->prepare("select distinct m1.bibid from
biblio,biblioitems,items,issues,reserves,marc_biblio,$sql_tables where
biblio.biblionumber=marc_biblio.biblionumber and
biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and
$sql_where2 and ($sql_where1) order by $orderby $desc_or_asc");
! warn "Q2 : select distinct m1.bibid from
biblio,biblioitems,items,issues,reserves,marc_biblio,$sql_tables where
biblio.biblionumber=marc_biblio.biblionumber and
biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and
$sql_where2 and ($sql_where1) order by $orderby $desc_or_asc term is @$value";
} else {
! $sth = $dbh->prepare("select distinct m1.bibid from
biblio,biblioitems,items,issues,reserves,marc_biblio,$sql_tables where
biblio.biblionumber=marc_biblio.biblionumber and
biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and
$sql_where1 order by $orderby $desc_or_asc");
! warn "Q : select distinct m1.bibid from
biblio,biblioitems,items,issues,reserves,marc_biblio,$sql_tables where
biblio.biblionumber=marc_biblio.biblionumber and
biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and
$sql_where1 order by $orderby $desc_or_asc";
}
$sth->execute();
--- 281,289 ----
my $sth;
if ($sql_where2) {
! $sth = $dbh->prepare("select distinct m1.bibid from
biblio,biblioitems,marc_biblio,$sql_tables where
biblio.biblionumber=marc_biblio.biblionumber and
biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and
$sql_where2 and ($sql_where1) order by $orderby $desc_or_asc");
! warn "Q2 : select distinct m1.bibid from
biblio,biblioitems,marc_biblio,$sql_tables where
biblio.biblionumber=marc_biblio.biblionumber and
biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and
$sql_where2 and ($sql_where1) order by $orderby $desc_or_asc term is @$value";
} else {
! $sth = $dbh->prepare("select distinct m1.bibid from
biblio,biblioitems,marc_biblio,$sql_tables where
biblio.biblionumber=marc_biblio.biblionumber and
biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and
$sql_where1 order by $orderby $desc_or_asc");
! warn "Q : select distinct m1.bibid from
biblio,biblioitems,marc_biblio,$sql_tables where
biblio.biblionumber=marc_biblio.biblionumber and
biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and
$sql_where1 order by $orderby $desc_or_asc";
}
$sth->execute();
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Koha-cvs] CVS: koha/C4 SearchMarc.pm,1.44,1.45,
Henri-Damien LAURENT <=