Active Record / SELECT NULL VALUES

Archives Yii 1.0.x Discussions
1

How is it possible to select NULL values from the database with Active Record ?

The code below doesn't show any results, but when I change condition to 'parentId is null' it works.

$menus = Menu::model()->with(array('menuContent'=> array('params' => array(':lang'=>$lang),


		                                                         'condition'=>'language=:lang')))->findAll(array('condition'=>'parentId=:parentId',


																											     'params'=> array(':parentId'=>$parentId)));
2

Unfortunately, this is not supported because of SQL syntax and the limit of PDO parameter binding.

3

thanks for answer:)