Forum OpenACS Development: acs-lang searching values of message keys for a locale

Collapse
1: acs-lang searching values of message keys for a locale
Posted by Torben Brosten on 09/29/05 10:42 AM
Given a table column containing acs-lang message_key values in place of short paragraphs of text, such as:

set example_table.title = '#package-key.${unique_id}#'

according to 'i18n methods for short strings': https://openacs.org/forums/message-view?message_id=296504

How does one code a search for the values in a il8n'd column in context of a user's locale?

Collapse
2: Re: acs-lang searching values of message keys for a locale (response to 1)
Posted by Malte Sussdorff on 09/29/05 11:21 AM
select * from example_table where title in (select message_key from lang_messages where package_key = 'acs-translations' and locale = :user_locale and message like '%:searchterm%')