[TYPO3-dev] TCA and own tables

Malte Jansen mail at maltejansen.de
Fri Apr 18 19:43:48 CEST 2008


Hi!

You might get problems with the leading zero.

You can get any field (one or more) as a label. Just use the alt_label & 
alt_label_force in $TCA['ctrl']. Check out the doc_core_api for details  ;)

Cheers,

Malte

Christian Leicht schrieb:
> Malte Jansen schrieb:
>>
>>>
>>> Hello again,
>>>
>>> now i implemented the database in Typo3. Now i use the foreign_table 
>>> reference list me the table entrys in the BE :-)))
>>> If i select some of this entrys, it will not store the values of the 
>>> listing. It stores the uid of the reference databes.
>>> Is it posible to store another field in the "master" table?
>>>
>>> Christian
>>
>> Hi,
>>
>> there two ways of storing a foreign key:
>>
>> 1. Storing one ore more UID(s) in the field
>> 2. Storing the a counter in the field and have two additional fields 
>> in the foreign table: foreign_table, foreign_uid
>>
>> Is there a reason for not using the uid? The get a record by the uid 
>> is much faster than by any other field (expected you make some more 
>> db-configuration).
>> I think the UID is hardcoded, so you have to use one of the 
>> possibility above.
>> Check out the doc_core_api for details (keyword: TCA).
>>
>> Cheers,
>>
>> Malte
> 
> The reason why i ask about it is...
> 
> I like to have a option list in BE with 2 fields in it.
> 
> Like
> 
> 01067 Dresden
> 45555 Frankfurt
> 20345 Hamburg
> ...
> 
> The Option list should have then
> <option value="01067">01067 Dresden</option>
> 
> But of course its also possible to use  <option value="uid#">01067 
> Dresden</option>
> 
> But is there a chance to get the 2nd field in it?
> 
> Christian
> 
> 
> 
> 
> 
> 
> 




More information about the TYPO3-dev mailing list