Re: PHP and PostgreSQL

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