CODEWITHSUNDEEP
mysqlsymfonydoctrineentity
Ivan Javier Barranco Gavilan
Ivan Javier Barranco Gavilan

Reputation: 503

Check if my query not return entity

when i try this:

$emGeneral = $this->get('doctrine.orm.default_entity_manager');
                    $idequipo= $emGeneral->getRepository('AgcManagerBundle:EquipoControl')
                       ->createQueryBuilder('p')
                       ->where('p.codigo = "'.$i["equipo"].'"')
                       ->getQuery()
                       ->setMaxResults(1000)
                       ->setFirstResult(0)
                       ->getResult();

I get the next error:

[2/2] QueryException: [Syntax Error] line 0, col 72: Error: Expected Literal, got '"'
[1/2] QueryException: SELECT p FROM Agc\ManagerBundle\Entity\EquipoControl p WHERE p.codigo = "0E150347"

Upvotes: 0

Views: 67

Answers (1)

xurshid29
xurshid29

Reputation: 4210

Dont pass an argument to where method directly, pass it to setParameter/Parameters method, like this:

$idequipo= $emGeneral->getRepository('AgcManagerBundle:EquipoControl')
                       ->createQueryBuilder('p')
                       ->where('p.codigo = :equipo')
                       ->setParameter('equipo', $i['equipo'])
                       ->getQuery()
                       ->setMaxResults(1000)
                       ->setFirstResult(0)
                       ->getResult();

Upvotes: 3

Related Questions