[TYPO3-german] Select Anweisung typoscript deleted=0

[Arnd Messer]

Hi Joachim,

--> OR
und nicht "or"

SELECT * FROM my_table
WHERE company LIKE 'A%'
OR company LIKE 'B%'

temp.memberlist = CONTENT
temp.memberlist {
   table = fe_users
   select {
      pidInList = 3
      orderBy = company
      where = company LIKE 'A%' OR company LIKE 'B%'
      andWhere = hidden=0
      andWhere =  deleted=0
    }
}


...righty?


arnd

> 
> temp.memberlist = CONTENT
> temp.memberlist{
>   table = fe_users
>   select {
>     pidInList = 3
>     orderBy = company
>     where = company LIKE 'A%' or company LIKE 'B%'
>     andWhere = hidden=0
>     andWhere =  deleted=0
>   }
> 
> }
>