From:             [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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to