$query = qq{INSERT INTO Tabelle1(ID,NEID,BState,Data_Cisco,MD5) VALUES(?,?,now(),?,?,?)}; $sth = $dbh->prepare($query) or die "Error in query prepare: $DBI::errstr\n"; $sth->execute($id,$NEID,'UP',$datacisco,$MD5) or die "Error executing query: $DBI::errstr\n"; $sth->finish();