index 20463d7827632a4700b0e8b78fb51b3d268a488c..e03152960c16d113e269f4e4368304dd9cd35ccd 100644 (file)
# if primkey is id, fetch max id from table and give new job id= max(id)+1
if ($primkey eq 'id') {
my $id;
- my $sql_statement = "SELECT MAX(id) FROM $table";
+ my $sql_statement = "SELECT MAX(CAST(id AS INTEGER)) FROM $table";
&create_lock($self,'add_dbentry');
my $max_id = @{ @{ $self->{dbh}->selectall_arrayref($sql_statement) }[0] }[0];
&remove_lock($self,'add_dbentry');