[TYPO3-dev] Views in TYPO3 database

[Rik Willems]

Hi Seffen,

Thanks for your reply!
What do you mean with raw statements exactly? Can't I use the normal 
t3lib_db functions?

Other databases than MySQL or DBAL compatibility isn't an issue in this 
case.

Rik

Op 7-3-2011 12:40, Steffen Kamper schreef:
> Hi,
>
> Am 07.03.2011 11:38, schrieb Rik Willems:
>> Howdy,
>>
>> I'm planning an extension that would need to show the same records on
>> different pages. For this I'm planning a m2m table like is common in
>> TYPO3.
>> But, I'd like my records not the have a single pid where it is
>> accessable through the 'list' function. Preferaby I'd like the record to
>> be edited through all pages it is on.
>>
>> Is it possible to make a view of the m2m and record table and add this
>> to TCA? This way the record would show up on all pages the m2m says it
>> is on.
>>
>> Looking forward to your thoughts.
>
> sure it's possible to make views. But then you are on MySQL only and you
> have to use raw statements. For sure DBAL compatibility isn't the case
> then.
>
> vg Steffen