> Take a look at http://book.cakephp.org/view/809/find-count i tried: $this->set('stati', $this->{$this->Singular}->Sito->Stato->find( 'list', array('fields'=>'DISTINCT stato') ) );
but results in a SQL error... the query generated is: SELECT `Stato`.`id`, DISTINCT `Stato`.` stato` FROM `stati` AS `Stato` WHERE 1 = 1 any suggestion? -- pietro --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---