2. ASPRunnerPro General questions
  3. [SOLVED]  Lookup & multilanguage
This topic is locked
[SOLVED]

 Lookup & multilanguage

 		9/17/2010 10:40:45 AM
ASPRunnerPro General questions
P
 Philip author

Hello
Is there a way to use a lookup table that the proposed list of values is in the correct language?

Actually I'm "cheating" by setting the display field in all languages used in the application as for example yes - ja - oui.

For short and common terms it's ok, but rather an ugly workaround. Any ideas how to improve?
Philip
Sergey Kornilov admin 9/17/2010

Philip,
if you store language in a separate column in lookup table you can add a WHERE clause that will filter out records you don't need.
Lookup table example
Language Value

---------------

French Bonjour

English Hi

Russian Привет
WHERE clause

" language='" & Session("language") & "'"
P
 		Philip author 9/20/2010

Sergey,
many thanks - this works fine!
Philip