Set boolean to 1 with doctrine

Question

I get some troubles with a very simple request that I try to make working with doctrine:

    return $this->createQueryBuilder('l')
                ->set('l.valide', true)
                ->andWhere('l.artiste=:artiste')
                ->andWhere('l.client=:client')
                ->andWhere('l.annonce=:annonce')
                ->setParameters(
                    array(
                        ':artiste' => $artiste,
                        ':client'  => $client,
                        ':annonce' => $annonce
                    ))
                ->getQuery()
                ->getResult();

The request is executing without errors, but the update is not. This request has to put 1 in the field 'valide'. Some items in the table is matching with the 3 where clause.

What is wrong ?

Thanks for help

Possible duplicate of http://stackoverflow.com/questions/4337751/doctrine-2-update-query-with-query-builder — Hermann Stephane Ntsamo, Oct 19 '14 at 13:52

score 1 · Accepted Answer · answered Oct 19 '14 at 14:02

Your query builder usage is absolutely wrong. I believe you run this code within a repository? Then your code should look like this:

$this->createQueryBuilder('l')
    ->update() // Forgotten update() method
    ->set('l.valide', true)
    ->andWhere('l.artiste=:artiste')
    ->andWhere('l.client=:client')
    ->andWhere('l.annonce=:annonce')
    ->setParameters(
    array(
        ':artiste' => $artiste,
        ':client'  => $client,
        ':annonce' => $annonce
    ))
    ->getQuery()
    ->execute(); // Execute, "not getResult". It's not a SELECT query.

Set boolean to 1 with doctrine

1 Answers1