Facing Problem With $Criteria->Compare While Performing A Search

Yii 1.1 General Discussion
1

Hi,

I am facing a problem with $criteria->compare while comparing an input date to the database date.

…

$criteria = new CDbCriteria();

$criteria->compare(“enquiry_date =’”.date(‘Y-m-d’, strtotime($_REQUEST[‘tDate’]))."’");

$modelEnq = TblEnquiry::model()->findAll($criteria);

…

This resulting empty array. I have declared enquiry_date as datetime field, and the input box is a datepicker that only inputting date not datetime to compare.

Please help.

Thanks

Kapur

2

First of all, compare() takes two arguments

http://www.yiiframework.com/doc/api/1.1/CDbCriteria#compare-detail

so your code should look something like this


$criteria->compare('enquiry_date', date('Y-m-d', strtotime($_REQUEST['tDate']));
3

Thanks Orey,

          I used '$criteria->condition' instead of compare and it works for me.