首页 文章

YII标准'With'关系问题

提问于
浏览 次
1
WHEN IAM TRYING TO GET invoice created user and grn created user i am getting this error...

CDbCommand无法执行SQL语句：SQLSTATE [42000]：语法错误或访问冲突：1066不唯一的表/别名：'user' . 执行的SQL语句是：SELECT t.id AS t0_c0，t .grn ......

$criteria->with = array(
                "invoice.user" => array('select' => 'display_name'),
                "grn.user" => array(
                    'select' => 'display_name',
                ),


    );

请帮我解决这个问题......

activerecord yii criteria

1 回答

  • 2

    您应该为这两种关系指定别名，如下所示：

    $criteria->with = array(
  "invoice.user" => array(
    'alias' => 'invoiceUser', 
    'select' => 'display_name'
  ),
  "grn.user" => array(
    'alias' => 'grnUser',
    'select' => 'display_name',
  ),
);
    回复于

相关问题