Re: find with null

THE ABOVE PROBLEM IS SOLVED (my second post).

THIS IS THE ONLY SOLUTION (so far) TO THE ABOVE PROBLEM.

I believe the solution is not too bad, despite being slightly off to
the cake conventions.
To overcome the problem pointed here a find-function-developer would
need to rewrite its work to take into consideration a special meaning
of null as not being treated a standard SQL value - cannot be part of
IN SQL statement.

Neither of the following will work:

'OR'=> array('title IS'=>null, 'title'=>$TitleArray)
- cake produces: SQL: (`title ` IS = NULL) - DB will not show null
values if requested in this way (tested MySQL)

$TitleArray = array('a', 'b', 'c', null);
- SQL does not interpret null in this (tested MySQL) - DB will not
show records with null value, will show others

'conditions' => array('title'=>null, 'OR' => array('title'=>
$TitleArray))
- cake produces SQL: `title` IS NULL AND title = (1) - this will not
show any values as both are contradicting each other (default AND
between statements, for OR values should be inside OR array

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en