Doctrine LIMIT Syntax Error?

Viewed 7232
'[Syntax Error] line 0, col 71: Error: Expected end of string, got 'LIMIT'' 

Here's my code:

public function getLatestChapters()
    {
        return $this->_em->createQuery('SELECT c, m FROM models\Chapter c JOIN c.Manga m ORDER BY c.CreateDate LIMIT 10')->getResult();
    }

What could posibly the problem for this? How can I use LIMIT in Doctrine?

I am using Doctrine 2

2 Answers
Related