[mech7]

How Do I perform a search on a related table? Something like:

$criteria=new CDbCriteria;
                $criteria->with=array(
                    'pages.content',
                );
                $criteria->condition = 'pages.content LIKE :keyword';
                $criteria->params = array(':keyword' => '%'.$q.'%');

                $bookCount = Books::model()->count($criteria);
                $pagination = new CPagination($bookCount);
                $pagination->pageSize = 10;
                $pagination->applyLimit($criteria);

                $books = Books::model()->findAll($criteria);

Does not work

[vamp]

mech7, on 15 March 2010 - 01:51 AM, said:

How Do I perform a search on a related table? Something like:

$criteria=new CDbCriteria;
                $criteria->with=array(
                    'pages.content',
                );
                $criteria->condition = 'pages.content LIKE :keyword';
                $criteria->params = array(':keyword' => '%'.$q.'%');

                $bookCount = Books::model()->count($criteria);
                $pagination = new CPagination($bookCount);
                $pagination->pageSize = 10;
                $pagination->applyLimit($criteria);

                $books = Books::model()->findAll($criteria);

Does not work

try:

	$criteria->with=array(
		'pages'=>array(
			'condition' => 'content LIKE :keyword',
		),
	);

[nemo]

mech7, on 15 March 2010 - 01:51 AM, said:

How Do I perform a search on a related table? Something like:

$criteria=new CDbCriteria;
                $criteria->with=array(
                    'pages.content',
                );
                $criteria->condition = 'pages.content LIKE :keyword';
                $criteria->params = array(':keyword' => '%'.$q.'%');

                $bookCount = Books::model()->count($criteria);
                $pagination = new CPagination($bookCount);
                $pagination->pageSize = 10;
                $pagination->applyLimit($criteria);

                $books = Books::model()->findAll($criteria);

Does not work

Can you post your search action controller