> ID: 9267
> Updated by: jmoore
> Reported By: [EMAIL PROTECTED]
> Old-Status: Open
> Status: Closed
> Old-Bug Type: *Database Functions
> Bug Type: MySQL related
> Assigned To:
> Comments:
>
> This seems due to PHP assuming MySQL's return values are strings, which
point it is converted into an empty sting. Probably your best bet is to test
for a "". I think this behaviour is documented somewhere.
>
> James
>
1) not mysql, mssql
2. it means that the mssql_result call failed for some reason, because
false was returned, not an empty string.
still, the bug should be closed ;-)
-Sterling
> Previous Comments:
> --------------------------------------------------------------------------
-
>
> [2001-02-22 13:30:58] [EMAIL PROTECTED]
> <?php
> $db = mssql_connect("localhost", "xxx", "yyy");
> mssql_select_db("zzz", $db);
>
> $result = mssql_query("select NULL as test", $db);
>
> mssql_fetch_row($result);
> $blah = mssql_result($result, 0, "test");
>
> $huh = NULL;
>
>
> echo is_null($blah); // false
> var_dump($blah); // bool(false)
>
> echo is_null($huh); // true
> var_dump($huh); // NULL
> ?>
>
>
>
> --------------------------------------------------------------------------
-
>
> [2001-02-22 05:26:38] [EMAIL PROTECTED]
> Could you provide a short example of a code that reproduces
> this?
>
> --------------------------------------------------------------------------
-
>
> [2001-02-14 17:06:49] [EMAIL PROTECTED]
> don't know if this is only related to the mssql extension, but when i
retrieve a NULL - field from the database the var will be set to "" or 0 or
whatever in php.
>
> is_null() returns false.
>
> harald.
>
> --------------------------------------------------------------------------
-
>
>
>
> ATTENTION! Do NOT reply to this email!
> To reply, use the web interface found at
http://bugs.php.net/?id=9267&edit=2
>
>
> --
> PHP Development 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]
>
--
PHP Development 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]
