Re: [PHP] Getting my head around nulls

2001-09-26 Thread Steve Cayford
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]

Re: [PHP] Getting my head around nulls

2001-09-26 Thread Ben . Edwards
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

Re: [PHP] Getting my head around nulls

2001-09-25 Thread Steve Cayford
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

RE: [PHP] Getting my head around nulls

2001-09-25 Thread Ben . Edwards
>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

RE: [PHP] Getting my head around nulls.

2001-09-25 Thread Ben . Edwards
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

RE: [PHP] Getting my head around nulls.

2001-09-25 Thread Johnson, Kirk
> 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

Re: [PHP] Getting my head around nulls.

2001-09-25 Thread Andrey Hristov
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

RE: [PHP] Getting my head around nulls.

2001-09-25 Thread Ben . Edwards
>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

RE: [PHP] Getting my head around nulls.

2001-09-24 Thread Johnson, Kirk
> And remember "0 as a number is as important as any other number". I wish the rest of the world saw it that way! But not so... 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 datab