From 0d8d2bbf276394e5ac6c0785c36e04cc9626160d Mon Sep 17 00:00:00 2001 From: Srdjan Jankovic Date: Wed, 7 Mar 2012 17:44:01 +1300 Subject: [PATCH] bug_7458: Correct existing existing call numbers retrieval Adjusted to account for duplicate call numbers in the database. Now retrieves next available call number correctly. --- cataloguing/value_builder/callnumber-KU.pl | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/cataloguing/value_builder/callnumber-KU.pl b/cataloguing/value_builder/callnumber-KU.pl index e0fa444..201f9c8 100755 --- a/cataloguing/value_builder/callnumber-KU.pl +++ b/cataloguing/value_builder/callnumber-KU.pl @@ -104,7 +104,7 @@ sub plugin { if ( my $first = $dbh->selectrow_array("SELECT itemcallnumber FROM items WHERE itemcallnumber = ?", undef, $padded) ) { - my $icn = $dbh->selectcol_arrayref("SELECT itemcallnumber + my $icn = $dbh->selectcol_arrayref("SELECT DISTINCT itemcallnumber FROM items WHERE itemcallnumber LIKE ? AND itemcallnumber > ? -- 1.7.2.5