table. Depending on the user's language settings (known from CGI variable HTTP_ACCEPT_LANGUAGE)- I could substitute info from the appropriate column- and then cache the page.
http_accept_language won't work 100%, probably should use geoLocator instead: mx: http://www.macromedia.com/cfusion/exchange/index.cfm?view=sn130#loc=en_us&view=sn131&viewName=ColdFusion%20Extension&extID=1005462 cf5: http://cftools.sdsolutions.de/ the normal approach to this is via resource bundles, what constitutes a "resource bundle" varies: db, xml (either per locale or all locales in a file), value pairs in a file (per locale). in the java world its value pairs in a file (per locale). > 1. Static text (HTML)- I could probably create 5 different HTML code snippets in each language and load those the same way. this will become a pain to maintain. use cf to generate static html or better yet cache the heck out what's "static". > 2. Maintaining translations for each table of concern- Maybe an alternative could be a separate table that has english keywords with their translations managing words? no at a minimum use phrases, at least you won't run into grammar problems trying to patch words into phrases (if thats what you mwant by that statement). > and I could a search on a list/structure of english-to-some-other-language key-value pairs. That way I could separate the actual queries from the translation itself. if you go the db route add a locale (or language) column to whatever db schema you're using to manage your content. > Any thoughts, criticisms, words of wisdom and/or encouragement welcome well...you completely missed dates (as well as calendars), numeric, currency formatting, text direction, etc. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
