delete via AR

Yii 1.1 General Discussion
1

I want to do some deleting…




$critiria = new CDbCriteria;

$critiria->order = 'id ASC';

$critiria->limit = '1';

$critiria->condition = 'type=:type';

$critiria->params = array(

':type'=> 3

);

CVarDumper::dump(OneXN::model()->findAll($critiria),10,true);

//not works ->

CVarDumper::dump(OneXN::model()->deleteAll($critiria),10,true);

why the last not work? the findAll added just to check it works, and it indeed works…

dont know how to use the AR delete for this one…

I can create method and go with dao…

I think the problem is that delete dont accept critiria, it accept some sort of array, so maybe someone will exmplain how to convert my critiria to array that delete all will understand

2

is there a way to delete by complicated critiria via AR ?

3

There is a CDbCriteria.toArray() function which should do the job.

Your deleteAll looks ok to me and I would expect it to work.

What is the result of your "not works"-deleteAll call?

Do you see an error message/stack?

If you don’t get any error you can try to find the problem by enabling tracing with category system.db.* or system.db.ar.*.

4

I get an error, it dont accept critiria… , it want some mixed array…

maybe CDbCriteria.toArray() will do the job, defiantly will check this one oout

5

toArray not working…