douhe5092 2015-09-28 19:03
浏览 26

cakephp明显发现错误

I am using cakephp2.7 and need to get distinct values from a table

$rows = $this->Skill->find('list',array(
            'conditions'=>array(
                    'Skill.status'=>1,
                    'Skill.percent >='=> 70,
                    'Skill.percent <='=> 100,
                ),
            'fields' => array('DISTINCT Skill.row AS row'),
            //'fields' => 'DISTINCT Skill.row AS row',/*also tried*/
        ));

but it is giving mysql error ...near DISTINCT....
generated query is as below

SELECT `Skill`.`id`, DISTINCT `Skill`.`row` AS `row` FROM `mydb`.`skills` AS `Skill` WHERE `Skill`.`status` = 1 AND `Skill`.`percent` >= 70 AND `Skill`.`percent` <= 100

i tried same query in mysql giving same error but when I remove id column in mysql query it is running fine.

now issue is that skill.id column is added in query automatically by cakephp and it is primary key how to prevent including id column in find()?

  • 写回答

0条回答 默认 最新

    报告相同问题?