createQueryBuilder and setParameter with multiple parameters?
<p>I've been trying to create this SQL query and i keep on having an error with a 2nd parameter.</p>

<p>Maybe i am missing something here.</p>

<p>Here is my request : </p>

<pre><code>$pointsTEF = $this-&gt;getDoctrine()-&gt;getManager();
                $pointsTEFs = $pointsTEF-&gt;createQueryBuilder('t')
                -&gt;select('t.points')
                -&gt;from('AppBundle:Tef', 't')
                -&gt;where('t.epreuve = :epreuve')
                -&gt;setParameter('epreuve',$valeur)
                -&gt;andWhere('t.resultat = :resultat')
                -&gt;setParameter('resultat',$valeurEpreuve)
                -&gt;getQuery()
                -&gt;getResult();
</code></pre>

<p>Is this the proper way of using setParameter(); ?</p>

<blockquote>
  <p>An exception occurred while executing 'SELECT t0_.points AS points_0
  FROM tef t0_ WHERE t0_.epreuve = ? AND t0_.resultat = ?' with params
  ["CE", "B1"]:</p>
  
  <p>SQLSTATE[HY093]: Invalid parameter number: Columns/Parameters are
  1-based</p>
</blockquote>