[TYPO3-english] DBAL and foreign_table in TCA.php
Aji Yahya
aji.yahya at gmail.com
Wed Mar 7 08:42:35 CET 2012
On 3/7/12 8:35 AM, Xavier Perseguers wrote:
> Hello Aji,
>
>> i was wondering if there is a way to use inside tca.php the
>> foreign_table for getting records from another table outside typo3 DB.
>> i have an extension using DBAL, everything working fine. if i try
>> foreign_table inside tca.php it is throwing:
>> DBAL fatal error: Tables in this list "tx_myext_table,pages" didn't use
>> the same DB handler!
>>
>> my code inside tca.php:
>>
>> ....
>> 'config' => array (
>> 'type' => 'select',
>> 'foreign_table' => 'tx_myext_table',
>> .....
>> .....
>> )
>
> You cannot create JOINs between two tables not in the same database.
>
> Kind regards
>
Hey Xavier,
Thank you for your quick response.
you are right. no JOINs in different DB's.
mapping of table:'pages' was not helpful too. :-(
regards
aji
More information about the TYPO3-english
mailing list