my $sql = <<EOSQL;

INSERT INTO test_table 
VALUES (?,?,?,?,?,?)

EOSQL
        my $sth = $dbh->prepare($sql);		
        $sth->execute('test_env', 
                      $partner,
                      $id, 
                      $filename, 
                      "$date $time", 
                      $line_count,
                      );