Ok, autant pour moi.
Alors voici le code :
$this->Application->bindModel(array('hasOne' =>
array('ApplicationEtat' => array('className' => 'ApplicationEtat'))));
$this->set('etat', $this->Application-
>find('all',array('conditions'=>array('ApplicationEtat.id'=>1))));
La requête :
SELECT Array, `Application`. FROM `applications` AS `Application` LEFT
JOIN `grpapplications` AS `Grpapplication` ON
(`Application`.`grpapplication_id` = `Grpapplication`.`id`) LEFT JOIN
`applications_etats` AS `ApplicationEtat` ON
(`ApplicationEtat`.`application_id` = `Application`.`id`) WHERE all
LIMIT 1
Et l'erreur SQL :
SQL Error: 1064: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'FROM `applications` AS `Application` LEFT JOIN
`grpapplications` AS `Grpapplicat' at line 1
--~--~---------~--~----~------------~-------~--~----~
Groupe "Cakephp-fr".
Adresse : cakephp-fr@googlegroups.com
Pour résilier : [EMAIL PROTECTED]
Pour les options : http://groups.google.com/group/cakephp-fr?hl=fr
-~----------~----~----~----~------~----~------~--~---
