php3-list | 199807

Re: [PHP3] How do I insert NULL??? From: Cary Collett (caryc <email protected>)
Date: 07/31/98

Richard Lynch (lynch <email protected>) said:

> I could be wrong: I frequently am...
>
> But I think y'all are over-engineering.
>
> Unless you've got some fancy way for the user to indicate that they really do want an empty string for a field, and thus shouldn't be asked to fill it in later, just put the empty string in, and when you want to find "blanks", search for the empty string.
>
> Convoluting your code to stick a NULL in instead of "" is silly, unless you actually want them to be distinct.
>

"" and NULL mean different things in SQL. eg IS NOT NULL will be true
for "" and false for NULL.

Cary 

-- 
Cary Collett                                           cary <email protected>

To me, boxing is like ballet, except there's no dancing, no choreography
and the dancers hit eachother.

--
PHP 3 Mailing List   http://www.php.net/
To unsubscribe send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest list:  php3-digest-subscribe <email protected>
For help: php3-help <email protected>  Archive:  http://www.php.net/mailsearch.php3