88 |
# If a prefix is submited, we look for the highest stocknumber with this prefix, and return it incremented |
88 |
# If a prefix is submited, we look for the highest stocknumber with this prefix, and return it incremented |
90 |
my $sth = $dbh->prepare("SELECT MAX(CAST(SUBSTRING_INDEX(stocknumber,' ',-1) AS SIGNED)) FROM items WHERE stocknumber LIKE ?"); |
90 |
my $sth = $dbh->prepare("SELECT MAX(CAST(SUBSTRING_INDEX(stocknumber,' ',-1) AS SIGNED)) FROM items WHERE stocknumber LIKE ?"); |