convert barcode to number in sql

[share-koha-fer] / intranet / cgi-bin / fer / inventura.pl

diff --git a/intranet/cgi-bin/fer/inventura.pl b/intranet/cgi-bin/fer/inventura.pl
index af0aa55..6d88bb4 100755 (executable)
--- a/intranet/cgi-bin/fer/inventura.pl
+++ b/intranet/cgi-bin/fer/inventura.pl
@@ -63,6 +63,8 @@ if ( $barcode ) {
 
        my $dbh = C4::Context->dbh;
 
+       warn "inventura barcode: $barcode ",dump($barcode);
+
        my $sql = qq{
        select
                itemnumber,
@@ -80,7 +82,7 @@ if ( $barcode ) {
        from items
        join biblio on items.biblionumber = biblio.biblionumber
        join biblioitems on items.biblionumber = biblioitems.biblionumber
-       where barcode = ?
+       where barcode = ? + 0
        };
 
        #warn "# sql $sql\n";