Limit amount of records retrieved when using Doctrine DQL in Symfony2

php sql doctrine-orm symfony dql
mickburkejnr picture mickburkejnr · Sep 13, 2011 · Viewed 31.5k times · Source

I have the following query:

   $latestcontent = $em->createQuery('
            SELECT c.title, c.content, c.lastedit, a.firstname, a.surname
            FROM ShoutMainBundle:Content c, ShoutMainBundle:Admin a
            WHERE c.author = a.id
            ORDER BY c.lastedit ASC'
            );

What I need to do, is limit the amount of records returned from this query. However, when I add LIMIT 10 to the SQL query, it returns this error:

Error: Expected end of string, got 'LIMIT'.

So, I had a look and found that you could do add ->limit(10) to the code (after the query). But this then throws up this PHP error:

Fatal error: Call to undefined method Doctrine\ORM\Query::limit() in C:\wamp\www\src\Shout\AdminBundle\Controller\DefaultController.php on line 22

What am I doing wrong?

Answer

Raffael picture Raffael · Sep 13, 2011

There is no statement like LIMIT for DQL currently, as far as I know.

You have to use Query::setMaxResults().

Related questions

How to ORDER BY DateTime in Doctrine 2?

I'm looking to execute the following query: $qb = $this->getEntityManager()->createQueryBuilder(); $qb->select( 'e' ) ->from( 'Entity\Event', 'e' ) ->setMaxResults( $limit ) ->setFirstResult( $offset ) ->orderBy('e.dateStart', 'ASC'); $events = $qb-&…

Read More
Left join ON condition AND other condition syntax in Doctrine

I'm using Doctrine's querybuilder in Symfony2 to create a query to fetch entities. My current code looks like this: $repository = $this->getDoctrine()->getRepository('AaaBundle:Application'); $queryBuilder = $repository->createQueryBuilder('a'); $queryBuilder ->addSelect('u') ->…

Read More
How do I use a complex criteria inside a doctrine 2 entity's repository?

Lets say I have a table that holds information about festivals. Each festival has a start and end date. I want to select all the festivals that are live (that happen) on a given date. Meaning, I want to select …

Read More