I linked them through an ID, but I need to display the name of the cities/regions, so I need to "join" the id in the house row with the name in the city table to francky06l , what do you mean cache? How can I use caching in cake?
On 26 Ott, 18:03, "J. Eckert" <[EMAIL PROTECTED]> wrote: > > In house index action I use findAll in all tables in order to show the > > Why are you using findAll on ALL tables? > > If your Models are corretly associated > ( > house belongsTo city > city belongsTo region > region belongsTo State > ) > you shouldn't get more information than you need if you do a > > $this->House->findAll(....) > > For every house you will get 1 city, 1 region, 1 state... > > On Oct 26, 12:01 pm, Paolo <[EMAIL PROTECTED]> wrote: > > > Hi all! > > I have a problem using cake. I have a table that is linked to it's > > geographical location > > (i.e. house -> ... city_id > > city -> ... region_id > > region -> -... state_id) > > city, region and state in the list of houses. The problem is that I > > have 8000 cities so i get out of memory error. Is there another way to > > associate the id to the name of the city (region and state)? > > > Thanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
