如果我在 phpMyAdmin 中为我的数据库运行下面的代码,那么我得到 17 条记录,但是当我在 TYPO3 6.1.4 中运行它时,我得到了数据库 (200) 中的所有记录,为什么它在 TYPO3 中不能 100% 工作,当它在 phpMyAdmin 中工作时。
public function getKategorierne($catId){
//print $catId;
$query = $this->createQuery();
$query->statement('SELECT * '.
'FROM sys_category_record_mm '.
'INNER JOIN sys_category ON ( uid = uid_local ) '.
'WHERE tablenames = "tx_origkentaurproducts_domain_model_design" '.
'AND sys_category_record_mm.uid_local '.
'IN ('.$catId.') '.
'ORDER BY uid_foreign');
return $query->execute();
}
为什么所有倒逗号?!?
$query = "
SELECT *
FROM sys_category_record_mm r
JOIN sys_category c
ON uid = uid_local
WHERE tablenames = 'tx_origkentaurproducts_domain_model_design'
AND r.uid_local IN ('$catId')
ORDER
BY uid_foreign;
";