#5590: Model->find should deal with NULL if its one of possible values
------------------------+---------------------------------------------------
Reporter: edmnc | Type: Enhancement
Status: new | Priority: Low
Milestone: 1.2.x.x | Component: Model
Version: RC3 | Severity: Minor
Keywords: | Php_version: n/a
Cake_version: |
------------------------+---------------------------------------------------
The following find definition:
{{{
$data = $this->Message->find('all', array(
'conditions' => array(
"Message.answer_id" => array($some_id, $other_id, null)
)
));
}}}
produces SQL with NULL in in() statement, i.e. the conditions part would
look something like this:
{{{
where `Message`.`answer_id` in (1,2,null)
}}}
For the SQL to return any rows with answer_id NULL, it should look
something like this:
{{{
where (`Message`.`answer_id` in (1,2) or `Message`.`answer_id` is null)
}}}
--
Ticket URL: <https://trac.cakephp.org/ticket/5590>
CakePHP : The Rapid Development Framework for PHP <https://trac.cakephp.org/>
Cake is a rapid development framework for PHP which uses commonly known design
patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC.
Our primary goal is to provide a structured framework that enables PHP users at
all levels to rapidly develop robust web applications, without any loss to
flexibility.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"tickets cakephp" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/tickets-cakephp?hl=en
-~----------~----~----~----~------~----~------~--~---
