[SLOVED] 关联的select指定,包含数据库函数,出错

关联代码:


'relAskList'=>array(

    self::HAS_MANY,

    'ArticleAsk',

    'ARTICLE_DETAIL_ID',

    'select'=>'ARTICLE_ASK_ID, ARTICLE_DETAIL_ID, ASK_DIRECTION, ASK_OTHER_ACTION, ASK_NOTE, ASK_USER_ID, TO_CHAR(ASK_TIME,\'dd/MM/yyyy hh24:mi:ss\')',

),



抛错:

CDbException

Description

Active record "ArticleAsk" is trying to select an invalid column "TO_CHAR(ASK_TIME". Note, the column must exist in the table or be an expression with alias.

mysql 貌似没有TO_CHAR方法

因为你的model没有那个字段名,你添加 as xx就可以了。这个xx是model的字段名。

你需要把select的字段用数组表达,否则yii是按照逗号分隔字段的,这样会导致你的TO_CHAR分隔出错。

原来如此~~ Great!