Problems with Doctrine 2 Query Builder

2019-04-20 00:50发布

问题:

I'm trying to build a query with Doctrine 2

$qb = $em->createQueryBuilder()
                  ->select('*')
                  ->from('Countries','c')
                  //getDQL
                  ->getQuery();

  echo "<pre>";
echo ($qb->execute());
echo "</pre>";
die;

for some reason I'm getting an error:

Fatal error: Uncaught exception 'Doctrine\ORM\Query\QueryException' with message '[Syntax Error] line 0, col 7: Error: Expected IdentificationVariable | StateFieldPathExpression | AggregateExpression | "(" Subselect ")" | ScalarExpression, got '*'' in /home/dodo/doctrine-orm/Doctrine/ORM/Query/QueryException.php on line 42

回答1:

There is no such a thing as "global wildcard" - you should use c.*.



回答2:

select('c.*') didn't work for me, select('c') was enough