Of course, depending on the application, this could mean hand-modifying
every script... so my apologies if this was not what you were after ;)
> Could it be as simple as:
> $sth = $dbh->prepare("INSERT INTO table (row1, row2) VALUES (?, ?)");
> if ( $webinput eq "" ) { $webinput = undef ; }
>
Could it be as simple as:
$sth = $dbh->prepare("INSERT INTO table (row1, row2) VALUES (?, ?)");
if ( $webinput eq "" ) { $webinput = undef ; }
$sth->execute($webinput, $otherstuff);
I don't have Postgres here to test on, but inserting an undef should
translate to a NULL on most any DBD.
Re