One method I've seen is to use a translation table.  Basically, you know
what info you're looking for, and the target language, and you can use this
to retrieve the required text.  I would avoid doing this for articles, but
stuff like navigation text, status messages, alert box text, etc. would work
ok.

So, basically, your table would be something like this:

TranslationTable
================
Language (pk)
MessageCode (pk)
TextValue
OrdinalValue

then a simple query like
        select Textvalue
        From TranslationTable
        Where MessageCode = 'Navigation'
        order by OrdinalValue

would get you the correct language, and the right order.  You might even be
able to tie this in with XML in some way to make life easier.

The other suggestions are valid as well, but I haven't seen them in action,
so can't really comment on them.

My thoughts.....

Shawn Grover

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 07, 2002 12:47 PM
To: CF-Talk
Subject: Bilingual App HELP!!


Hey guys, any of yall Familiar with the Houston International 
Festival?  Well it's like this festival that features music, dance, 
arts, and spotlights a different country every year.  Well this year 
that country is MEXICO.

And they want to have an English and Spanish version.  I would like 
some ideas on methods on approaching this.  Everything will be 
identical.  Layout, grpahics.  The only difference is the langage 
(and of course, text on the navigation buttons will change too).  But 
i was wondering if there are any veterans :)

Ideally, I would like to have only one copy, instead of an English 
copy and a Spanish copy.  That way they use the same CFM code.  A 
bulk of the site would be text and information.  So i was thinking 
maybe I can just set the text to variables, and display the correct 
language depending on their preference.  Just text only though!  
There will be only one HTML code, and only one CFM code to follow.  
So well, there you go!  I appreciate any input, humour, pity :)

snifflebear






______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to