php - "Couldn' t 找到类“Doctrine 子查询

Question

我正在使用 Symfony 1.4 和 Doctrine。我有一个名为 Image 的 Doctrine 类和一个(应该)通过查询查找下一个和上一个值的方法。违规代码如下所示:

$q = Doctrine_Core::getTable('Image')->createQuery()
            ->from('Image i')
            ->where('i.id = (select max(a.id) from Image a where ? > a.id and is_active = 1)', $this->getId())
            ->orWhere('i.id = (select min(b.id) from Image b where ? < b.id and is_active = 1)', $this->getId());

我总是得到

500 | Internal Server Error | Doctrine_Exception Couldn't find class a

错误。有什么提示吗？

Answer 1

好吧，事实证明 Doctrine 在这种情况下是区分大小写的。工作代码如下所示:

$q = Doctrine_Core::getTable('Image')->createQuery()
            ->from('Image i')
            ->where('i.id = (SELECT MAX(a.id) FROM Image a WHERE ? > a.id AND is_active = 1)', $this->getId())
            ->orWhere('i.id = (SELECT MIN(b.id) FROM Image b WHERE ? < b.id AND is_active = 1)', $this->getId());