CODEWITHSUNDEEP
symfonydoctrinedql
Kristen Joseph-Delaffon
Kristen Joseph-Delaffon

Reputation: 1291

Doctrine query builder - Too few parameters

I made a Doctrine query builder query and I have this error :

Too few parameters : The query defines 3 parameters but you only bound 2.

I have looked at the query and tried some refactoring but I can't find where the code is wrong.

The query :

$query = $this->_em->createQueryBuilder();
$query->select('m')
      ->from(Matiere::class, 'm')
      ->join('m.ues', 'ue')
      ->andWhere($query->expr()->eq('ue.semester', ':semestre'))
      ->setParameter('semestre', $semestre);

if (count($UEs) === 1) {
    $query->andWhere($query->expr()->neq('ue.id', ':ueSpe'))
          ->setParameter('ueSpe', $UEs);
}
else {
    $ueM = $UEs[0];
    $ueP = $UEs[1];
    $query->andWhere($query->expr()->neq('ue.id', ':ueM'))
          ->andWhere($query->expr()->neq('ue.id', ':ueP'))
          ->setParameters(['ueM' => $ueM, 'ueP' => $ueP]);
}
return $query->getQuery()->getResult();

Upvotes: 0

Views: 2911

Answers (2)

Parijit Kedia
Parijit Kedia

Reputation: 21

setParameters() overrides any previous setParameter() call. So, you have to individually set properties using setParameter, or make sure they dont overlap by using an if condition.

Upvotes: 1

l13
l13

Reputation: 529

$query = $this->_em->createQueryBuilder();
$query->select('m')
      ->from(Matiere::class, 'm')
      ->join('m.ues', 'ue')
      ->andWhere($query->expr()->eq('ue.semester', ':semestre'))
      ->setParameter('semestre', $semestre);

if (count($UEs) === 1) {
    $query->andWhere($query->expr()->neq('ue.id', ':ueSpe'))
          ->setParameter('ueSpe', $UEs);
}
else {
    $parameters[] = $UEs[0];
    $parameters[] = $UEs[1];
    $query->andWhere($qb->expr()->notIn('ue.id', ':parameters'))
          ->setParameter('parameters' => $parameters);
}
return $query->getQuery()->getResult();

Upvotes: 1

Related Questions