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 at manual, ifnull() seems
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] Getting my head around nulls
On Tuesday, September 25, 2001
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 to
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 don't have any good advice. It seems that if you retrieve a
NULL from
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]
Thanks for
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
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, ifnull()
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 is
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
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 several types of nulls). MySQL implements this
correctly (Unlike
Oracle
10 matches
Mail list logo