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
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
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
David Stoltz wrote:
$rs-Fields(22) equals a NULL in the database
My Code:
if(empty($rs-Fields(22))){
$q4 = ;
}else{
$q4 = $rs-Fields(22);
}
Produces this error:
Fatal error: Can't use method return value in write context in
D:\Inetpub\wwwroot\evaluations\lookup2.php on
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. Second,
you cant use a function/method in empty(). Thirdly, the string NULL
is not empty. I'm not sure what DB class you're using here or
5 matches
Mail list logo