[Typo3] select.where - more values from comma separated list outof database

JoH info at cybercraft.de
Wed Apr 27 15:09:23 CEST 2005


> ... I have to extend a class... guess it could work with a PHP
> Patch... something like
>
> $tx_asimmoext_typ = explode(",", $row['tx_asimmoext_typ']);
>
> ??... i'm quite tough in typoscript, but i guess if i want to get
> more into typo3 i have to learn php from the base....
>
> look:
> http://www.typotemp.com/uploads/a_mysql_liste.gif

You don't need PHP for this.
Simply use "andWhere" instead of "where".
"andWhere" has stdWrap properties, so you can do something like this:

andWhere.cObject = COA
andWhere.cObject {
    10 = TEXT
    10.field = tx_asimmoext_typ
    10.noTrimWrap = | fieldname IN (|) |
    20 = TEXT
    20.value = AND something else here
}

Joey

-- 
Wenn man keine Ahnung hat: Einfach mal Fresse halten!
(If you have no clues: simply shut your knob sometimes!)
Dieter Nuhr, German comedian
openBC: http://www.openbc.com/go/invuid/Jo_Hasenau





More information about the TYPO3-english mailing list