[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