[TYPO3-english] Re: Typoscript SQL query into Formhandler

[Christophe Duhamel]

Ok...
I found 2 errors in my code :

1st : I forgot "=" after "JOIN"
2nd : It seem it's not possible to have two "join" clause into a typoscript "CONTENT" object.

So I decide to test with a "view" into my database. So I will not need anymore to join the tables...
To do that, I have make an empty extension (with extension builder) for just write a tca with my view but actually I have an new error : "There is no entry in the $TCA array for the table "tx_dbview". This means that the function enableFields() is called with an invalid table name as argument."

Here my TCA : http://pastebin.com/6uWer3kQ

Questions : 
How can I setup this view (as table) into $TCA ?
What do you think about that ? Is it a good solution ?


Thanks