How to specify null value as filter in a Doctrine query?

php null doctrine dql
Mr B picture Mr B · Mar 1, 2011 · Viewed 76.8k times · Source

I am using Doctrine 1.1 in Zend. I am trying to write a query that will return records that have a null value in a certain column.

    $q = Doctrine_Query::create()
    ->select('a.*')
    ->from('RuleSet a')
    ->where('a.vertical_id = ?', null);

    $ruleset_names_result = $q->execute(array(), Doctrine::HYDRATE_ARRAY);

I have three records in the ruleset table which have a NULL value in the vertical_id column yet the query doest not find these.

Appreciate the help.

Sid.

Answer

Johannes picture Johannes · Mar 1, 2011

I use doctrine with symfony, and this is how I do:

where('a.vertical_id is NULL');

Related questions

php is null or empty?

I have a question regarding NULL in PHP: $a = ''; if($a == NULL) { echo 'is null'; } Why do I see is null when $a is an empty string? Is that a bug?

Read More
PHP json_decode() returns NULL with valid JSON?

I have this JSON object stored on a plain text file: { "MySQL": { "Server": "(server)", "Username": "(user)", "Password": "(pwd)", "DatabaseName": "(dbname)" }, "Ftp": { "Server": "(server)", "Username": "(user)", "Password": "(pwd)", "RootFolder": "(rf)" }, "BasePath": "../../bin/", "NotesAppPath": "notas", "SearchAppPath": "buscar", "BaseUrl": "http:\/\/montemaiztusitio.com.ar", "…

Read More
MySQL and PHP - insert NULL rather than empty string

I have a MySQL statement that inserts some variables into the database. I recently added 2 fields which are optional ($intLat, $intLng). Right now, if these values are not entered I pass along an empty string as a value. How do …

Read More