[TYPO3-english] enablefields on join select (and in Typoscript)

Henjo Hoeksma hphoeksma at stylence.nl
Mon Jul 6 12:03:10 CEST 2009


Hi list,

I am running into issues with an extension for products that get's all 
the products based on a join of two tables. For this extension I am 
using IRRE.
I have only found a way to have the enableFields on one of the 2 
tables, but run into issues now that I actually need them to check 
both...

Any clue on how to achieve this?

Currently what I do is something like this:

<code>
$mTable = explode(',',$table);
$where = 
$this->getListWhere($mTable[0]).$this->cObj->enableFields($mTable[0]).' 
AND '.$mTable[1].'.classificationid='.$classificationRestriction.' AND 
'.$mTable[0].'.uid='.$mTable[1].'.productid';
</code>

Next question: is there a possibiltity to use enableFields in 
Typoscript? I couldn't find it... but would love it to be there...

Thanks in advance for your thoughts.

Henjo
-- 
Stylence | webdevelopment in style
www.stylence.nl



More information about the TYPO3-english mailing list