php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #11090 where with null
Submitted: 2001-05-24 12:33 UTC Modified: 2001-05-25 09:45 UTC
From: jcastro at elnuevodia dot com Assigned:
Status: Closed Package: ODBC related
PHP Version: 4.0.5 OS: Windows 2000 Professional
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: jcastro at elnuevodia dot com
New email:
PHP Version: OS:

 

 [2001-05-24 12:33 UTC] jcastro at elnuevodia dot com
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



Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-05-25 09:45 UTC] kalowsky@php.net
SQL syntax should be "table_name.num_b IS NOT NULL"
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Tue May 06 02:01:28 2025 UTC