doctrine 2 multiple join in one query give me error

Question

I have query with two MtM relations:

        $em = $this->getEntityManager();

        $qb = $em->createQueryBuilder();
        $qb
            ->select('o')
            ->from('UserBundle:User', 'o')
            ;

        $qb->join('o.organisations', 'org')
            ->where('org.id = :organisation')
            ->setParameter('organisation', $filterData['organisation'])
        ;
        $qb
            ->join('o.scientificDirections', 'd')
            ->where('d.id IN (:directionIds)')
            ->setParameter('directionIds', $directionIds)
            ->orderBy('o.surname')
            ;
        return $qb->getQuery();

But it gives me error: Invalid parameter number: number of bound variables does not match number of tokens. Can anybody explain me what is wrong? Relation in User model:

/**
 * @ORM\ManyToMany(targetEntity="\StrangeBundle\Entity\ScientificDirection")
 *
 */
protected $scientificDirections;

/**
 * @ORM\ManyToMany(targetEntity="\StrangeBundle\Entity\Organisation", mappedBy="workers")
 */
protected $organisations;

Gohn67 · Accepted Answer · 2012-03-25 06:26:37Z

3

I think the reason is because you used where twice. That overwrites the first where, which is why it is giving you the parameters number error.

Use andWhere

answered Mar 25, 2012 at 6:26

Gohn67

10.7k2 gold badges32 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

doctrine 2 multiple join in one query give me error

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