Cakephp 1.3查找所有现在和未来最多5个记录总数


cakephp 1.3 find all now and future up to 5 records total

我在查询返回预期结果时遇到麻烦。从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()");