Re: ORACLE_HOME environment variable not set

2001-04-02 Thread Daniel Kirkwood
Hello All, I have a similar issue with some Perl scripts that are invoked by QMail - the scripts process email on a command-response type system, interacting with an Oracle database. Or at least - that's the idea :) Qmail sets its own Enviroment variables to scripts it calls (i'm using a pipe fr

Re: NULL vs. Empty String

2001-03-13 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 ; } >

Re: NULL vs. Empty String

2001-03-13 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