model内怎样用limit [ 新手入门 ]

它不是也有个offset属性吗？

说的没错，应该是criteria的offset属性！

return new CActiveDataProvider('WriteDatabase',array(
  'criteria'=>$criteria,
  'sort'=>array(
    'defaultOrder'=>'t.id asc',
  ),
  'pagination'=>array(
    'pageSize'=>12,
    'offset' => 13,
  ),
));

这样么，好像报错.......

return new CActiveDataProvider('WriteDatabase',array(
  'criteria'=>$criteria,
  'pagination'=>array(
    'pageSize'=>12,
    'currentPage' => 2,
  ),

这样直接取第二页也没效果

应该是criteria的offset属性！

查一下API就明白了！

$criteria=new CDbCriteria;
$criteria->with='user';
$criteria->compare('id',$this->id);
$criteria->compare('article_id',$this->article_id);
$criteria->compare('article_user_id',$this->article_user_id);
$criteria->compare('user_school_id',$this->user_school_id);
$criteria->compare('creat_time',$this->creat_time,true);
$criteria->limit=12;
$criteria->offset=13;
return new CActiveDataProvider(get_class($this), array(
  'criteria'=>$criteria,
));
}

这样用就没效果，我要去13到24之间的结果.........