[fw-general] DISTINCT clause in a select() over ZEND_Db_Table

[Denis Fohl]

Hi all,

i can't manage myself to get it work :
        public function countLevels() {
                $select = $this->select();
                $select->from($this,'COUNT(DISTINCT idparent');
                return $this->fetchAll($select);
        }

this method is declared in a db_table object and i've got the following 
error :
Zend_Db_Statement_Exception: SQLSTATE[42S22]: Column not found: 1054 
Unknown column 'menu_element.COUNT(DISTINCT idparent' in 'field list' in 
E:\phplib\Zend\Db\Statement\Pdo.php on line 238

I've look to adding expression colomuns in documentation but can't find 
the way.

Thank you for your help