my $sql = qq(INSERT INTO db.table("field1","field2","field3") VALUES( ?, ?,now())); my $sth = $dbh->prepare($sql) or die "Not prepared: ".DBI->errstr; $sth->execute($var_field1,$var_field2) or die "Not executed: ".DBI->errstr;