[TYPO3-english] DBAL and foreign_table in TCA.php

[Aji Yahya]

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