I am trying to get a count, using this query:
$count = $entityManager->getRepository('Model:Machine')
->createQueryBuilder('m')
->select('COUNT(m.id)')
->where('m.number = :number')
->setParameter('number', $value)
->getQuery()
->getSingleScalarResult();
If I use a $value
that I know exists, then $count
returns as 1
.
If I use a value that I know does NOT exist, then $count
is empty.
Why isn't it set to 0
?
Thanks