Re: PHP and PostgreSQL

Michael, I know this will work, working directly in the database, I've tested it extensively. My problem is that when you do the insert through a PHP script, it doesn't work, spaces are inserted no matter what you do. Corey On Tue, 4 Jul 2000, Michael Teter wrote: > Ok I just tested this: > > "insert into tableBlah (name, review) values > ('me',NULL)" > > That does insert a NULL for review. > > Then I do this: > > "select * from tableBlah where review is NULL" > > I get: > > name | review > ------+--------- > me | > > So inserting the NULL does work. You just need to > programmatically build your insert statement such that > you put "NULL" where review goes, or "'the review > string'" if there's a real value. > > michael > > > --- Corey Mosher <corey@hub.org> wrote: > > Michael, > > > > This does not work for me, I have tried it already. > > > > Corey > > > > On Tue, 4 Jul 2000, Michael Teter wrote: > > > > > "insert into someTable (someColumn) values (NULL)" > > > > > > or > > > > > > $someVar = "NULL" > > > "insert into someTable(someColumn) values > > ($someVar)" > > > > > > or if you're not sure if someVar will have a real > > > value or instead a null value, do this: > > > > > > ...test $someVar... is it null or all space? > > > yes: $someVar = "NULL" > > > no: $someVar = "'" . $someVar . "'" > > > > > > then do this again: > > > "insert into someTable(someColumn) values > > ($someVar)" > > > > > > michael > > > > > > --- Corey Mosher <corey@hub.org> wrote: > > > > Hi, > > > > I am trying to do an insert into my > > postgreSQL > > > > database > > > > from a form. When I try to insert a null value, > > it > > > > gets > > > > put into the database as a string of spaces. > > Any > > > > ideas as to > > > > why and how to insert the correct null value? > > > > > > > > Corey Mosher > > > > Hub.Org Networking Services > > > > Wolfville, NS > > > > Canada > > > > corey@hub.org > > > > > > > > > > > > > > > > -- > > > > PHP General Mailing List (http://www.php.net/) > > > > To unsubscribe, e-mail: > > > > php-general-unsubscribe@lists.php.net > > > > For additional commands, e-mail: > > > > php-general-help@lists.php.net > > > > To contact the list administrators, e-mail: > > > > php-list-admin@lists.php.net > > > > > > > > > > > > > __________________________________________________ > > > Do You Yahoo!? > > > Kick off your party with Yahoo! Invites. > > > http://invites.yahoo.com/ > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: > > php-general-unsubscribe@lists.php.net > > > For additional commands, e-mail: > > php-general-help@lists.php.net > > > To contact the list administrators, e-mail: > > php-list-admin@lists.php.net > > > > > > > Corey Mosher > > Hub.Org Networking Services > > Wolfville, NS > > Canada > > corey@hub.org > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: > > php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: > > php-general-help@lists.php.net > > To contact the list administrators, e-mail: > > php-list-admin@lists.php.net > > > > > __________________________________________________ > Do You Yahoo!? > Kick off your party with Yahoo! Invites. > http://invites.yahoo.com/ > Corey Mosher Hub.Org Networking Services Wolfville, NS Canada corey@hub.org