[Typo3] select table pages - multilanguage?

Simon Tuck e-mailNO at SPAMeyejet.com
Mon Oct 24 22:55:09 CEST 2005


Adam Nojszewski wrote:
> Hello
> 
> Here is fragment of my code:
> ----
>  20 = CONTENT
>  20 {
>    table = pages
>    select {
>     pidInList = 58
>     orderBy = sorting
>     max = 3
>    }
>    renderObj = COA
>    renderObj {
>     10 = TEXT
>     10.field = title
> ...
> ----
> 
> My question is: how to get page title in active language? For tt-content 
> it is simple:
> ----
> ...
>      table = tt_content
>      select {
>       pidInList.field = uid
>       where = colPos=0
>       orderBy = sorting
>       languageField = sys_language_uid
>      }
> ...
> ----
> 
> but table pages does not have sys_language_uid field.
> 
> 
> regards

table = pages_language_overlay
select {
	pidInList = 58
	orderBy = sorting
	max = 3
	languageField = sys_language_uid
}

cheers,
Simon



More information about the TYPO3-english mailing list