mysql - Syntax error - Doctrine\ORM\Query\QueryException -


this query using:

$q = $this->getentitymanager()->createquerybuilder("select e actionmodule\action e join e.type t t.id in (:ids)"); 

i have tried every parameter assigning option:

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

and 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 lot in advance

edit:

i've dumped $q->getquery()->getdql() , got: "select" (6)

createquerybuilder doesn't accept arguments , purpose creating queries using builder methods, not dql.

what need createquery.

$q = $this->getentitymanager()->createquery("select e actionmodule\action e join e.type t t.id in (:ids)"); 

Comments