List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:May 4 1999 11:35pm
Subject:Re: Access to a Database
View as plain text  
On Tue, May 04, 1999 at 03:00:09PM +0200, Daniel Lacal wrote:
>           $sql="select * from usuarios where email !=null";

Agckhhh!  Don't try that.  Use "IS NOT NULL" instead.  Or better
yet, make the column NOT NULL in your CREATE TABLE statement and
then say "WHERE email <> ''" in your code.  No, they aren't the
same thing.  But you aren't being careful with NULL values, so
it'd be better for your programs if you don't use them anywhere!

Please, everyone, NULL and = don't mix!

Tim
Thread
Access to a DatabaseDaniel Lacal4 May
  • Re: Access to a DatabaseMassimo Ferrario4 May
  • Re: Access to a DatabaseThimble Smith5 May