[TYPO3-english] tca : multiple items in one fields

[Gregory Loichot]

Well, I change : maxitems" => 1, in maxitems" => 2. But when I save, I 
have an SQL error… what should I change in my sql table ?

Le 16.03.10 12:47, Gregory Loichot a écrit :
> Hello,
>
> In my T3 4.2.6, I created an extension. Suppose this extension has 2 sql
> tables (area and subarea).
>
> AREA fields (except T3 fields) : name, comments
> SUBAREA fields (except T3 fields) : name, subarea_uid
>
> In my tca.php file I have :
>
> $TCA["tx_myext_subarea"] =
> ...
> "subarea_uid" => Array (
> "exclude" => 1,
> "label" =>
> "LLL:EXT:myext/locallang_db.xml:tx_myext_reservation.subarea_uid",
> "config" => Array (
> "type" => "select",
> "foreign_table" => "tx_myext_area",
> "foreign_table_where" => "ORDER BY tx_myext_area.uid",
> "size" => 1,
> "minitems" => 0,
> "maxitems" => 1,
> )
> ),
> ...
>
> That works very well. But now, I want to be able to select more than one
> area for one subarea. How can I do that ? And what does it mean at sql
> level (have to add fields, tables) ?
>
> Thank you very much for your answer.
> Greg