Re: [PHP] Re: How to output a NULL field?
On Thu, Aug 27, 2009 at 9:37 AM, David Stoltz wrote: > You're a genius - that works! > > > -Original Message- > From: Bastien Koert [mailto:phps...@gmail.com] > Sent: Wednesday, August 26, 2009 2:02 PM > To: Andrew Ballard > Cc: Shawn McKenzie; php-general@lists.php.net; David Stoltz > Subject: Re: [PHP] Re: How to output a NULL field? > > > One option then, might be to format the result with SQL using a CASE > WHEN THEN statement or ISNULL / IFNULL to set it to empty string > > -- > > Bastien > > Cat, the other other white meat > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > Let me do this simple question... is your Sql Server legal? Then use it. If not, why don't you migrate to an open source alternative? there are a lot of DB you can use, and if you use an open source alternative then it's legal, that's mean you, or your client, do not have to pay for use it. I'm not going to say *that* DB is better that *this* other, this is a matter of taste. -- Martin Scotta
RE: [PHP] Re: How to output a NULL field?
You're a genius - that works! -Original Message- From: Bastien Koert [mailto:phps...@gmail.com] Sent: Wednesday, August 26, 2009 2:02 PM To: Andrew Ballard Cc: Shawn McKenzie; php-general@lists.php.net; David Stoltz Subject: Re: [PHP] Re: How to output a NULL field? One option then, might be to format the result with SQL using a CASE WHEN THEN statement or ISNULL / IFNULL to set it to empty string -- Bastien Cat, the other other white meat -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: How to output a NULL field?
On Wed, Aug 26, 2009 at 12:06 PM, Andrew Ballard wrote: > On Tue, Aug 25, 2009 at 3:22 PM, Shawn McKenzie wrote: >> First off, if the value is NULL in the database then in PHP it will be >> the string "NULL" and not a null value as far as I remember. > > I've not seen this happen. I've found, depending on the database and > the data access library used to interface with it that NULL usually > comes back as either the PHP NULL value or an empty string. > > Andrew > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > One option then, might be to format the result with SQL using a CASE WHEN THEN statement or ISNULL / IFNULL to set it to empty string -- Bastien Cat, the other other white meat -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: How to output a NULL field?
On Tue, Aug 25, 2009 at 3:22 PM, Shawn McKenzie wrote: > First off, if the value is NULL in the database then in PHP it will be > the string "NULL" and not a null value as far as I remember. I've not seen this happen. I've found, depending on the database and the data access library used to interface with it that NULL usually comes back as either the PHP NULL value or an empty string. Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php