hello, i have a simple code like this: $param = array('order'=>array('Stato.stato', 'Sito.sito'));
$this->Materiale->recursive = 2; $this->set('materiali', $this->Materiale->find('all', $param)); $this->render('printer', 'blank', '/materiali/printer'); my relations are: Materiale belongsto Sito Sito belongsto Stato if i run the code above, it gives me error: SQL Error: 1054: Unknown column 'Stato.stato' in 'order clause' but with recursive = 2, this should work and if i substitute the order with: $param = array('order'=>array('Sito.sito')); this doesn't give me error, and, first of all, it shows me in the view the Stato! it's like Stato it's included usually, but not i I use it in 'order'.. some ideas? thank you -- 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 -~----------~----~----~----~------~----~------~--~---