hi all,
Iwant to make a TV (selectbox) that gets populated based on another TV namely 'language'.
so when the user creates a new page and selects the proper template the selectbox only has the right entries based on the language.
My TV 'language' is an @INHERIT and is set by the toplevel folders EN NL and DE.
For my selectbox i now have a @SELECT
@SELECT `pagetitle` AS `name`,`id` FROM `[[+PREFIX]]site_content` WHERE `parent` = 120 AND `deleted` = 0
Now how can i make the parent ID variable based on the allready present TV language?
tnx