Error In Model Search Criteria

Yii 1.1 General Discussion
1

What is the error in model search(). Any error on assignment ?




   	public function searchinstitute()

	{

		$criteria=new CDbCriteria;

                ...............

		$criteria->compare('name',$this->name,true);

                if($this->country_name!='')

                     $criteria->addCondition("addressbooks.country='$this->country_name'",true);

                if($this->region_name!='')

                     $criteria->addCondition("countrymaster.regionname='$this->region_name'");


		return new CActiveDataProvider($this, array(

			'criteria'=>$criteria,

		));

	}

my output query:

   WHERE ((nameLIKE :ycp0) 1 (addressbooks.country='india')) AND (countrymaster.regionname='region')
2

Dear Brother

would you please try the the following.




public function searchinstitute()

{

         $criteria=new CDbCriteria;

         ...............

         $criteria->compare('name',$this->name,true);

         if(isset($this->country_name) && $this->country_name!='')

                 $criteria->addCondition('addressbooks.country='.$this->country_name);

         if(isset($this->region_name) && $this->region_name!='')

                 $criteria->addCondition('countrymaster.regionname='.$this->region_name);


         return new CActiveDataProvider($this, array(

                        'criteria'=>$criteria,

                ));

}