[Koha-bugs] [Bug 729] Add Child process doesn't check for unique barcode number

[bugzilla-daemon at wilbur.katipo.co.nz]

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=729

chris at katipo.co.nz changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |ASSIGNED



------- Additional Comments From chris at katipo.co.nz  2004-04-28 21:21 -------
Hmm this got well broken in the changes between version 1.3 and 1.4
my $query="Select * from borrowers where
borrowernumber=$data{'bornumber_child_$i'}";
my $sth=$dbh->prepare($query);
$sth->execute;

Became
my $x = "cardnumber_child_$i";
my $sth=$dbh->prepare("Select * from borrowers where borrowernumber=?");
$sth->execute($x);

Which is never gonna work it should be 
my $x = $data{'bornumber_child_$i'};

Otherwise everytime you try to update a child you'll end up creating a new
record. I'll fix that, and also make it protest if you try to insert a
cardnumber that already exists



------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.