hey perl DB coders

[SkaBob]

How can I insert a null value when using positional parameters?

Code: Select all

my $sql = 'INSERT INTO foo (col1, col2) VALUES (?, ?)';
my $sth = $dbh->prepare($sql);
my $rc = $sth->execute($var1, $var2);


What can I put in the values of $var1 or $var2 above if I want to insert a null, rather than the string 'NULL', which tends to go asplodey when the column is an int or bool, or other non-text field?

[SkaBob]

n/m...solved it myself. Passing undef works.