On Wednesday, September 26, 2001, at 02:48 AM, [EMAIL PROTECTED]
wrote:
>
>
>
>
>
>
> Steve Cayford <[EMAIL PROTECTED]> on 25/09/2001 17:28:57
>
>
>
> To: [EMAIL PROTECTED]
> cc: [EMAIL PROTECTED], [EMAIL PROTECTED]
> Subject: Re: [PHP]
Steve Cayford <[EMAIL PROTECTED]> on 25/09/2001 17:28:57
To: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: [PHP] Getting my head around nulls
On Tuesday, September 25, 2001, at 10:30 AM, [EMAIL PROTECTED]
wrote:
>>
>> Just had a look
On Tuesday, September 25, 2001, at 10:30 AM, [EMAIL PROTECTED]
wrote:
>> Thanks for correcting my misspelling, Andrey, "IS NULL" not "IS_NULL".
>> Another thing to look at, Ben, is IFNULL(). I would give you an
>> example,
> but
>> I never got it to work like I thought it should ;) I think it
>Thanks for correcting my misspelling, Andrey, "IS NULL" not "IS_NULL".
>Another thing to look at, Ben, is IFNULL(). I would give you an example,
but
>I never got it to work like I thought it should ;) I think it is supposed
to
>return an alternate value for NULLs.
Just had a look at manual, ifnu
Just realised, you meant 'is null' not is_null. Sorry, couldn't see the
wood for the trees. This in ANSI SQL and I use it every day.
Had a look at zootweb.com. And I thought ASP meant 'Active Server Pages'
not 'Application Service Provider'. And not a zoot suit in sight -;)
Regards,
Neb
> SELECT * from some_table WHERE some_field IS NULL;
>
>
> Andrey Hristov
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
Th
Subject: RE: [PHP] Getting my head around nulls.
> >I wish the rest of the world saw it that way! But not so...
>
> That's what capitalism does for you -;)
>
> >You may want to look at MySQL's IS_NULL function for retrieving data.
> Other
> >than that, I d
>I wish the rest of the world saw it that way! But not so...
That's what capitalism does for you -;)
>You may want to look at MySQL's IS_NULL function for retrieving data.
Other
>than that, I don't have any good advice. It seems that if you retrieve a
>NULL from the database and try to assign it
nday, September 24, 2001 8:59 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP] Getting my head around nulls.
>
>
> First recap (been doing RDBMS stuff for over 10 years so
> reckon this is
> correct). Nulls and blank are NOT the same in RDBMS (in fact
> there are
> actually s
First recap (been doing RDBMS stuff for over 10 years so reckon this is
correct). Nulls and blank are NOT the same in RDBMS (in fact there are
actually several types of nulls). MySQL implements this correctly (Unlike
Oracle which treats null and blank the same). Up to now I am OK but when
it co
10 matches
Mail list logo