Yeah, that's right. There's a place in my application where I can check
every argument passed and change them from empty strings to undef where
relevant, but I'd rather avoid that overhead if there's some sort of
PostgreSQL and/or DBI configuration that'll do it for me.
Thanks!
David
On Wed, 14 Mar 2001, Daniel Kirkwood wrote:
>
> 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 ; }
>
> > $sth->execute($webinput, $otherstuff);
