[TYPO3] Getting title out of tt_news

[Patrick Schlaepfer]

So, that seems to be working:

temp.newsMenu = CONTENT
temp.newsMenu {
     table = tt_news
     select {
          // Where are the tt_news records
          pidInList = 2
          orderBy = tstamp DESC
          selectField = uid,tstamp,title
          // Getting the uid of the news
          andWhere.data = GPvar:tx_ttnews|tt_news
          andWhere.wrap = uid = |
     }
     renderObj =  TEXT
     renderObj {
          wrap = <title>: |</title>
          // tt_news DB Feld das als Linktext benutzt werden soll
          field = title
     }
}

temp.newsMenu is then <title>: [news_title]</title>

> and sorry, you should use RECORDS which fits much better but needs
> another syntax
>
> georg
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>