Cactive Data Provider

Hi,

I want to sort my alpha numeric data in cdbcriteria. My data are a1,a2,a11 etc…

it is sorting in the following order,

a1

a11

a2

a3

i want in the below order,

a1

a2

a3

a11

Kindly help me soon. Thanks in advance.

i want to show this result in admin screen. Is there any way to solve this. I want to perform filter also after displaying the value.

$dataProvider=new CActiveDataProvider(‘model name’, array(

‘sort’=>array(

'defaultOrder'=>'field name order(asc or desc)',

)

));

Hi Ravi,

After giving this condition only am getting this result. For alphanumeric this condition wont work properly.