Hi all,

first of all, thank you very much for your
quick answers. But I don't think it has
something to do want you mentioned so far.
The relevant code is really nothing more than
this snippet:

---------------------%<-----------------------
print "Before connect\n";
$dbh = DBI->connect($DSN, $DBUSER, $DBPASSWD,
        { RaiseError => 1, AutoCommit => 1}) ||
        die "Error while connecting to database: $DBI::errstr";
print "After connect\n";
$sth = $dbh->prepare(q# insert into blabla(str1, str2) values (?,?);#) ||
        die "Error while preparing statement: $DBI::errstr";
my(@cols) = ('string', undef);
$rv = $sth->execute(@cols);
print "Before disconnect\n";
$dbh->disconnect();
print "After disconnect\n";
---------------------%<-----------------------

I get no error, I see the record in the database, BUT
the second column 'str2' has the string 'null' (small
letters) and not NULL.

Bye
Andreas Mock

Reply via email to