il manque un peu la moitié de ce dont tu parles...
pourrais tu être un chouille plus clair si tu veux de l'aide stp ?
Commence par poser ta question verbalement et illustre là après par exemple.
C'est, en général, plus simple.
Le 13/08/07, farphadet <[EMAIL PROTECTED]> a écrit :
>
>
> Bonjour,
>
>
> Voila j'ai les modéles suivants:
>
> class Currency extends AppModel {
> var $name = 'Currency';
> var $hasMany = array('Country');
> }
>
> class Country extends AppModel {
>
> var $name = 'Country';
> var $belongsTo = array('Currency');
> var $hasMany = array('LangCountry');
> }
>
> class LangCountry extends AppModel {
>
> public $name = 'LangCountry';
> public $belongsTo = array('Country');
> }
>
> J'utilise un Country->find(); qui me renvoie le tableau suivant:
>
> Mais en executant deux requetes sq, qui sont :
>
> 2007-08-13 17:32:17 CEST LOG: statement: SELECT "Country"."id" AS
> "Country__id", "Country"."currency_id" AS "Country__currency_id",
> "Country"."countries_iso_code_2" AS "Country__countries_iso_code_2",
> "Country"."countries_iso_code_3" AS "Country__countries_iso_code_3",
> "Country"."tel_regexp" AS "Country__tel_regexp", "Country"."zip_code"
> AS "Country__zip_code", "Currency"."id" AS "Currency__id",
> "Currency"."title" AS "Currency__title", "Currency"."code" AS
> "Currency__code", "Currency"."symbol" AS "Currency__symbol" FROM
> "countries" AS "Country" LEFT JOIN "currencies" AS "Currency" ON
> ("Country"."currency_id" = "Currency"."id") WHERE 1 = 1
>
> 2007-08-13 17:32:17 CEST LOG: statement: SELECT "LangCountry"."id" AS
> "LangCountry__id", "LangCountry"."country_id" AS
> "LangCountry__country_id", "LangCountry"."name" AS
> "LangCountry__name", "LangCountry"."diminutive" AS
> "LangCountry__diminutive" FROM "lang_countries" AS "LangCountry"
> WHERE "LangCountry"."country_id" IN ('1')
>
>
> Array ( [0] => Array ( [Country] => Array ( [id] => 1 [currency_id] =>
> 2 [countries_iso_code_2] => FRA [countries_iso_code_3] => FR
> [tel_regexp] => [zip_code] => ) [Currency] => Array ( [id] => 2
> [title] => Euro [code] => EURO [symbol] => EURO ) [LangCountry] => Array
> ( [0] => Array ( [id] => 4 [country_id] => 1 [name] => France
> [diminutive] => fr ) [1] => Array ( [id] => 5 [country_id] => 1 [name]
> => francia [diminutive] => es ) ) ) )
>
>
>
>
>
> Comme vous pouvez le voir pour l'association LangCountry il
> me renvoie deux autres sous tableau. Ce que j'aimerai faire
> c'est pouvoir mettre une condition de façons a ne récuperer
> que les valeur de l'un des Tableau renvoyé dans l'association
> LangCountry par exemple correspondant à 'diminutive' = fr.
>
>
> J'ai tester cela:
>
> Country->find(array('LangCountry.diminutive' =>'LIKE fr');
>
> Mais cela ne passe car l'opération d'apres mes logs base de
> données se fait en deux requetes sql. Donc je me retrouve
> avec la 1ere requete qui ressemble a cela :
>
>
> ELECT "Country"."id" AS "Country__id", "Country"."currency_id" AS
> "Country__currency_id", "Country"."countries_iso_code_2" AS
> "Country__countries_iso_code_2", "Country"."countries_iso_code_3" AS
> "Country__countries_iso_code_3", "Country"."tel_regexp" AS
> "Country__tel_regexp", "Country"."zip_code" AS "Country__zip_code",
> "Currency"."id" AS "Currency__id", "Currency"."title" AS
> "Currency__title", "Currency"."code" AS "Currency__code",
> "Currency"."symbol" AS "Currency__symbol" FROM "countries" AS
> "Country" LEFT JOIN "currencies" AS "Currency" ON
> ("Country"."currency_id" = "Currency"."id") WHERE
> "LangCountry"."diminutive" Like 'fr'
>
>
>
> Ce qui ne correponsd à rien du tout et me renvoie une erreur.
>
>
> Merci pour votre aide
>
>
> >
>
--
Guillaume Darbonne (aka. Guidouil)
http://www.cmapage.com
--~--~---------~--~----~------------~-------~--~----~
Groupe "Cakephp-fr".
Adresse : [email protected]
Pour résilier : [EMAIL PROTECTED]
Pour les options : http://groups.google.com/group/cakephp-fr?hl=fr
-~----------~----~----~----~------~----~------~--~---
