[TYPO3] DB selection form TS and WHERE

[Roberto Torresani]

Hi Andrea!

2006/11/28, Andrea Giorgini <a.giorgini at norvlit.de>:

> Andrea Giorgini wrote:
> > Hi,
> >
> > I successfully see the result of
> >
> > temp.POM = COA
> > temp.POM {
> >       10 = RECORDS
> >       10 {
> >               tables = tt_products
> >               source = 1
> >               #where = offer = 1
> >               conf.tt_products < temp.SETPOM
> >       }
> > }
> >


try to see the page
http://typo3.org/documentation/document-library/references/doc_core_tsref/current/view/5/5/

for example you should use:

page.10.subparts.NEWS = CONTENT
page.10.subparts.NEWS {
  table = tt_content
  select {
    pidInList = 1
    orderBy = sorting
  }
}

Bye
Roberto