[TYPO3] optionSplit for use in where in query

manolobimbo (Emmanuel Brost) manolobimbo at manolobimbo.com
Wed Jul 16 11:05:23 CEST 2008


Hi,
i'm answering to myself

I find it. Since optionSplit can't be used. substring make the trick and 
i can avoid the las colon.

        newsuids.cObject=CONTENT
        newsuids.cObject{
            table=tt_news
            select{
                pidInList=28
            }
            renderObj=TEXT
            renderObj{
                field= uid
                wrap= |,
               
            }
            stdWrap.substring=0,-1
        }

manolobimbo (Emmanuel Brost) a écrit :
> hi,
>
> i'd like to construct a sql query using the where..in clause, somathing 
> like "... IN (12,25,78)".
> I thought optionSplit was the way to the solution but  i don't know how 
> to use it in my typoscript.
> I'm still quite a newbie having difficulties with the stdWrap concept
>
> Here is the code:
> newsuids.cObject=CONTENT
>       newsuids.cObject{
>           table=tt_news
>           select{
>               pidInList=28
>           }
>           renderObj=TEXT
>           renderObj{
>               field= uid
>               wrap= |*|,|*|,|*|
>           }
>       }
>
> i don't think the usage of wrap is the good since i allways get wrong 
> results whatever i try.
>
> Any help would be greatly appreciated...
>
> Emmanuel Brost
>
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>
>
>
>   



More information about the TYPO3-english mailing list