CDbCriteria: Remove limit

I want to remove the limit option in the CDbCriteria. By default it has LIMIT 10. I want to display all the records from the particular table without any limit. For instance: SELECT * FROM tbl_name

[b]

[/b]

Can any one suggest me how to remove it.

Thank you for help.

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

CDbCriteria::limit is by default -1… so I presume you are using CGridView or CListView and there you have by default pagination with 10 records by default…

To disable that set the pagination of the CActiveDataProvider to false - http://www.yiiframework.com/doc/api/1.1/CDataProvider#pagination-detail

Thank you friends. :)