[TYPO3-dev] TCA and own tables

Christian Leicht usenet at schani.com
Thu Apr 17 17:54:20 CEST 2008


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




More information about the TYPO3-dev mailing list