[TYPO3-dev] tca.php and ext_tables.php - complete failure to understand

[Fr. Simon Rundell SCP]

Dear Typo3 Friends,

It's been some time that I got completely stuck but no amount of rereading
the API document or looking at other documents can make any sense.

I have a tt_content extension field which I want to populate with data from
another table and display in the plugin configuration

It would be great if the select included uid, firstname and surname (but I
can't see anywhere documented how to pull a concatenated field or multiple
fields from that foreign table) and store the uid in that tt_content field.

I have changed the config in ext_tables for the field in question to:

"tx_pdcontactblock_userid" => Array (
"exclude" => 0,
"label" =>
"LLL:EXT:pd_contactblock/locallang_db.xml:tt_content.tx_pdcontactblock_userid",
"config" => Array (
"type" => "select",
"foreign_table" => "tx_pddiocesedatabase_person",
'foreign_table_where' => 'AND tx_pddiocesedatabase_person.deletedrecord=0
ORDER BY tx_pddiocesedatabase_person.surname ASC',
"size" => "1",
"minitems" => 0,
"maxitems" => 1,
)
),

but this shows

"invalid value ('120')" (the field contains the integer 120) and doesn't
shopw anything like the uids I am expecting.

I get the impression that tca.php is also involved but have no clue as to
how!

Someone must be able to pull data into a plugin config screen and tell me
how it's done!

Any help hugely appreciated!

S+


Fr. Simon Rundell SCP
Vicar, Parish of S. Thomas the Apostle, Elson
The Vicarage, 21 Elson Road, Gosport, Hants, UK, PO12 4BL
Tel: 02392 582824  Fax: 02392 368092  Mob: 07976 802123
email: simon at rundell.org.uk
web:   http://www.saintthomaselson.org.uk/
blog:   http://frsimon.wordpress.com
Twitter: frsimon

NEW BOOK FOR THE SUMMER - Creative Ideas in Sacramental Alternative Worship
by Simon Rundell, from SCM-Canterbury Press. Why not consider pre-ordering?
See
http://www.amazon.co.uk/Creative-Ideas-Alternative-Sacramental-Worship/dp/1848250231/ref=sr_1_3?ie=UTF8&s=books&qid=1270230712&sr=8-3