->Addbetweencondition And Cdbexpression?

Thomas_Jensen · April 9, 2013, 7:16pm

What’s wrong about this code?




$criteria = new CDbCriteria();

$criteria->addBetweenCondition('created', new CDbExpression('DATE_SUB(NOW(), INTERVAL 48 HOUR)'), new CDbExpression('NOW()'));

$criteria->limit = 2;

MyModel::model()->findAll($criteria);

It returns just the two top most rows disrespecting the between clause.

Thanks!

cmijares117 · January 6, 2014, 10:10pm

I have the same problem!!! help

Thomas Jensen:

What’s wrong about this code?
$criteria = new CDbCriteria();

$criteria->addBetweenCondition('created', new CDbExpression('DATE_SUB(NOW(), INTERVAL 48 HOUR)'), new CDbExpression('NOW()'));

$criteria->limit = 2;

MyModel::model()->findAll($criteria);
It returns just the two top most rows disrespecting the between clause.

Thanks!

Angel_De_La_Noche · January 6, 2014, 11:10pm

What is the query generated? You can see it in logs.