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

[Xavier Perseguers]

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

-- 
Xavier Perseguers
Release Manager TYPO3 4.6

TYPO3 .... inspiring people to share!
Get involved: http://typo3.org