[schmunk]

Hi,

how can I create SELECT ... AS statements with a criteria?

like ...

$criteria->select = "CONCAT(a,B) AS c";

but this does not work.

Best regards,
schmunk

[PoL]

Did you try to declare a public variable in the model that uses that criteria? (in this case the variable must be called $c)

[schmunk]

No, I just wanted to do some custom things in my SELECT statement, I do not want a public variable for that.

Maybe I have to stick with this:
http://www.yiiframew...er#findAllBySql

[Sander]

You can probably do this with the combination of alias and CDbExpression.

[mech7]

mmm you ever find a solution? am hitting against the same wall I dont see how alias or CDBExpression can help ?

[butching]

PoL, on 05 February 2010 - 07:24 AM, said:

Did you try to declare a public variable in the model that uses that criteria? (in this case the variable must be called $c)

thanks Im having the same problem and now I can use the alias when I declared it as public variable on my model.. thanks a lot

[reed1]

PoL, on 05 February 2010 - 07:24 AM, said:

Did you try to declare a public variable in the model that uses that criteria? (in this case the variable must be called $c)

Don't know it was that easy lol, thanks