I'll be facing this same issue very soon. I've had a look at the I18N table structure and I'm also unsure how to proceed (or that it even suits my needs).
One trick I was thinking about is something I've already done fr years building English/French sites. Where I have a lookup table with values for select lists, I have fields ID, name_en, and name_fr. With Cake, one can set the display field before doing a find('list'). Here's an example from my MembersController, where I want populate a select list with region names: $this->Member->Region->displayField = "name_${lang}"; $this->set('regions', $this->Member->Region->find('list')); Then $regions can be passed in the view to create your select list and will contain only the english region names. ($lang is gotten from the session but has a default to avoid problems). Now, how to deal with other content i haven't figured out yet. On Thu, Feb 21, 2008 at 9:16 AM, Werschinger <[EMAIL PROTECTED]> wrote: > > The data is dynamic, it is stored in the DB. > > Loosely speaking, I have data like > > in English: > id: 1 > desc: male > id: 2 > desc: female > > in German > id: 1 > desc: männlich > id: 2 > desc: weiblich > > When somebody choose a gender (or a country or some other data) the ID > will be stored as a foreign key. > > Now...I could, of course, store the English string in the DB and pull > them via __() when German or some other language is required. However, > in that case, I'd have to recreate a data array as one string at a > time is returned by __(). Doesn't seem like an elegant solution to me. > > I'm just curious if this problem is supposed to be solved via the i18n > table as proposed in Cake 1.2. At this point, I just don't know how to > use the proposed table structure as found in app/config/sql/i18n.sql. > > In other posts, I have read that other tables in the form model_i18n > need to be generated. I just have not found a step by step example of > how to use i18n. > > Does anybody know? > > Thx again. > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---