Cdbcriteria Order By Field(Xx,0), Xx Asc

RTJ · January 11, 2013, 10:01am

[color=#1A1A1A]Hola,[/color]

[color=#1A1A1A]Como puedo hacr algo parecido a esta consulta con [/color][font="Lucida Sans Unicode, Lucida Sans, Lucida Grande, Malayalam, Verdana, sans-serif"][size="2"][color="#1a1a1a"]CDbCriteria[/color][/size][/font][color=#1A1A1A]


SELECT * FROM YY ORDER BY FIELD(xx,0), xx asc;

[/color]

sebas · January 11, 2013, 12:21pm

RTJ:

[color="#1A1A1A"]Hola,[/color]

[color="#1A1A1A"]Como puedo hacr algo parecido a esta consulta con [/color][font="Lucida Sans Unicode, Lucida Sans, Lucida Grande, Malayalam, Verdana, sans-serif"][size="2"][color="#1a1a1a"]CDbCriteria[/color][/size][/font][color="#1A1A1A"]
SELECT * FROM YY ORDER BY FIELD(xx,0), xx asc;
[/color]

Hola,

Probá esto:




$models = MyModel::model()->findAll(array('order'=>'FIELD(idinvited_email,3,4,1,2)'));

o




$dbCriteria = new CDbCriteria();

$dbCriteria->order = 'FIELD('myfield', 3,4,1,2)';

$models = MyModel::model()->findAll($dbCriteria);

Saludos!