[GENERAL] Re: NULL vs. Empty String

2001-03-14 Thread Daniel Kirkwood
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 ; } >

[GENERAL] Re: NULL vs. Empty String

2001-03-14 Thread Daniel Kirkwood
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