[Koha-cvs] CVS: koha/C4 Breeding.pm,1.4,1.5

[Chris Cormack]

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

Modified Files:
	Breeding.pm 
Log Message:
Fix for bug 761
Ill commit this to the rel-2-0 branch as well


Index: Breeding.pm
===================================================================
RCS file: /cvsroot/koha/koha/C4/Breeding.pm,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -r1.4 -r1.5
*** Breeding.pm	25 Oct 2003 08:46:28 -0000	1.4
--- Breeding.pm	24 Mar 2004 00:36:07 -0000	1.5
***************
*** 61,65 ****
  	my $searchisbn = $dbh->prepare("select biblioitemnumber from biblioitems where isbn=?");
  	my $searchissn = $dbh->prepare("select biblioitemnumber from biblioitems where issn=?");
! 	my $searchbreeding = $dbh->prepare("select id from marc_breeding where isbn=?");
  	my $insertsql = $dbh->prepare("insert into marc_breeding (file,isbn,title,author,marc,encoding,z3950random) values(?,?,?,?,?,?,?)");
  	my $replacesql = $dbh->prepare("update marc_breeding set file=?,isbn=?,title=?,author=?,marc=?,encoding=?,z3950random=? where id=?");
--- 61,66 ----
  	my $searchisbn = $dbh->prepare("select biblioitemnumber from biblioitems where isbn=?");
  	my $searchissn = $dbh->prepare("select biblioitemnumber from biblioitems where issn=?");
! 	my $searchbreeding = $dbh->prepare("select id from marc_breeding
! where isbn=? and title=?");
  	my $insertsql = $dbh->prepare("insert into marc_breeding (file,isbn,title,author,marc,encoding,z3950random) values(?,?,?,?,?,?,?)");
  	my $replacesql = $dbh->prepare("update marc_breeding set file=?,isbn=?,title=?,author=?,marc=?,encoding=?,z3950random=? where id=?");
***************
*** 100,107 ****
  				my $breedingid;
  				if ($oldbiblio->{isbn}) {
! 					$searchbreeding->execute($oldbiblio->{isbn});
  					($breedingid) = $searchbreeding->fetchrow;
  				} elsif ($oldbiblio->{issn}){
! 					$searchbreeding->execute($oldbiblio->{issn});
  					($breedingid) = $searchbreeding->fetchrow;
  				}
--- 101,108 ----
  				my $breedingid;
  				if ($oldbiblio->{isbn}) {
! 					$searchbreeding->execute($oldbiblio->{isbn},$oldbiblio->{title});
  					($breedingid) = $searchbreeding->fetchrow;
  				} elsif ($oldbiblio->{issn}){
! 					$searchbreeding->execute($oldbiblio->{issn},$oldbiblio->{title});
  					($breedingid) = $searchbreeding->fetchrow;
  				}