[PHP-DEV] Bug #11090: where with null From: jcastro <email protected>
Date: 05/24/01

From: jcastro <email protected>
Operating system: Windows 2000 Professional
PHP version: 4.0.5
PHP Bug Type: ODBC related
Bug description: where with null

Database sybase

The following select works using slq advantage and returns values but when I use php I get nothing and NO errors either.

SELECT
    table_name.num_a,
    table_name.num_b
from table_name
where table_name.num_b <> null and
      table_name.num_a=1111

I also tried

SELECT
    table_name.num_a,
    table_name.num_b
from table_name
where table_name.num_b != null and
      table_name.num_a=1111

In both cases I get no results but when using SQL adavantage from sybase I get the expected results.

The problems comes with the line
table_name.num_b != null

It seems like a bug. Please advise.

Thank you 

-- 
Edit Bug report at: http://bugs.php.net/?id=11090&edit=1

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>