[TYPO3] Formfields from database (feeding a valueArray from the Database)

[Frank Berger]

Hi Folks,
I don't know if that can be done at all, or if there is a better way to do
that.. essentialy this is what i am trying (which doesn't work at all):

the mailform is just an example, I could imagine other forms as well where i
would want that..

tt_content.mailform.20 {

  dataArray {


                40.label = Kategorien:

40.type = category=select


                40.valueArray {

                     10.label=Please select

                     10.value =

                     table = my_categories

                     select {

                         orderby = category

                         selectFields = uid,category

                     }

                 }

  }

}


I want do feed the data for a valueArray from a certain table (which is
properly configured in $TCA). Additionaly i would like to add a field which
is not in the database at all (please select)


I am sorry, but I frankly don't have any clue what i should or could do at
this point. Google was fruitless for me, as i didn't find a similar question
or solution or idea for a solution.


thanks in advance for any hint

Frank