[web2py] Re: Multi language database query

2016-04-25 Thread Niphlod
that query is largely inefficient though. use response.toolbar() to see how many queries that statement generates. I really don't get how the data is stored into the model. example records of each table and of the resultset would be beneficial to craft the needed query On Friday, April 22,

[web2py] Re: Multi language database query

2016-04-22 Thread Marko Seppälä
I think that that reference in language_tr table is needed. Otherwise there is no way to translate those for more than one language I think. For example, if we have two languages, let's say English and German, and we want to translate both languages to both languages. So for example language

[web2py] Re: Multi language database query

2016-04-22 Thread Niphlod
imho there's a reference not needed (the language_id in the language_tr table) that being said...let's build queries, step by step """ Basically I'm looking for a list of language_tr elements which has a translation_id which has a language_id which is same than users selected system language.