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 Thu, Aug 27, 2009 at 9:37 AM, David Stoltz dsto...@shh.org 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?
On Wed, Aug 26, 2009 at 12:06 PM, Andrew Ballardaball...@gmail.com wrote: On Tue, Aug 25, 2009 at 3:22 PM, Shawn McKenzienos...@mckenzies.net 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