Problems with Doctrine 2 Query Builder

2019-04-20 00:30发布

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

2条回答
家丑人穷心不美
2楼-- · 2019-04-20 00:45

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

查看更多
Summer. ? 凉城
3楼-- · 2019-04-20 00:52

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

查看更多
登录 后发表回答