php - Typo3 $this->cObj->enableFields() SQL 错误 WHERE AND

Question

我使用这一行进行数据库选择:

$res = $TYPO3_DB->exec_SELECTquery('*', $table, $this->cObj->enableFields($table), '' , '', '');

问题是 SQL 错误:

从 xyz WHERE AND 中选择 * xyz.deleted=0 AND.......

有人知道为什么会发生这种情况吗？我使用enableFields函数处理where Clouse的方式有问题吗？

Answer 1

TYPO3 wiki

If you don't already have a WHERE clause, you will get a wrong SQL statement ("SELECT * FROM tt_address WHERE AND ..."), so you have to strip the leading AND

使用'1'.$this->cObj->enableFields($table)