[TYPO3-dev] TCA and own tables

[Steffen Kamper]

"Christian Leicht" <usenet at schani.com> schrieb im Newsbeitrag 
news:mailman.1.1208447650.1913.typo3-dev at lists.netfielders.de...
> Hello,
>
> in test enviroment, i like to implement a table that is not in the TCA and 
> so not have a uid.
>
> If i reference to this table > foreign_table" => "textdata",
>        "foreign_table_where" => "AND text_type = 500300000 GROUP BY 
> text_val ORDER BY text_val",
>
> the SELECT statement have an error
> Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch 
> nachschlagen bei 'FROM textdata,pages
> WHERE
> pages.uid=textdata.pid
> AND ' in Zeile 2
>
> off corse
>
> Is there a chance to reference to this table whitout change the structure 
> of the table?
>
> Thanks for help
>
> Christian

Hi,

you can't use foreign_table_where without having TCA for this table, so make 
one.
look to t3lib_befunc::exec_foreign_table_where_query

vg Steffen