This question has been asked before but was not answered, to my knowledge. Does DBD::ADO in any way support null insertion placeholders? The following example code illustrates the problem:
my $name = "";
$sth = $dbh->prepare('INSERT INTO Staff (name) VALUES(?)');
$sth->execute($name);
That works fine under DBD::ODBC, but fails under DBD::ADO when accessing the
same data source. Any ideas?
