我在查询返回预期结果时遇到麻烦。从cakephp 1.1迁移到1.3。目前,我的新查询没有返回任何结果。一旦我得到结果,我需要限制在5。现在()在我的$sqlConditions
数组中正确吗?有什么建议吗?谢谢你的关注。
旧查询cakephp 1.1:
function listcomingevents() {
$conditions="EventsDate.start_date>=now()";
$this->weekevent="EventsDate.start_date ASC";
$listcomingeventdata=$this->EventsDate->findAll($conditions,'',$this->weekevent,'5');
return $listcomingeventdata;
}
new query cakephp 1.3:
function listcomingevents() {
$sqlConditions = array( "EventsDate.start_date >="=>"now()");
//remaining code
$sqlOrderBy = array("EventsDate.start_date asc");
$sqlParams = array('conditions'=>$sqlConditions,'order'=>$sqlOrderBy);
$listcomingeventdata=$this->EventsDate->find('all',$sqlParams);
return $listcomingeventdata;
}
也尝试:
$sqlConditions = array("EventsDate.start_date >="=>"CURDATE()");
将NOW()
表达式直接放在左侧,例如
$sqlConditions = array( "EventsDate.start_date >= CURDATE()");