Syntax error - Doctrine\ORM\Query\QueryException

Question

This is the query I am using:

$q = $this->getEntityManager()->createQueryBuilder("SELECT e FROM ActionModule\Action e JOIN e.type t WHERE t.id IN (:ids)");

I have tried every parameter assigning option:

:ids
?1
implode(',', $ids)
?ids

And always get:

Doctrine\ORM\Query\QueryException

[Syntax Error] line 0, col -1: Error: Expected IdentificationVariable | ScalarExpression | AggregateExpression | FunctionDeclaration | PartialObjectExpression | "(" Subselect ")" | CaseExpression, got end of string

Thanks a lot in advance

EDIT:

I've dumped $q->getQuery()->getDql() and got: "SELECT" (6)

meze · Accepted Answer · 2013-05-06 06:31:03Z

4

createQueryBuilder doesn't accept any arguments and its purpose is creating queries using the builder methods, not DQL.

What you need is createQuery.

$q = $this->getEntityManager()->createQuery("SELECT e FROM ActionModule\Action e JOIN e.type t WHERE t.id IN (:ids)");

answered May 6, 2013 at 6:31

meze

15.1k4 gold badges49 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Syntax error - Doctrine\ORM\Query\QueryException

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related