Top "Dql" questions

Limit amount of records retrieved when using Doctrine DQL in Symfony2

I have the following query: $latestcontent = $em->createQuery(' SELECT c.title, c.content, c.lastedit, a.firstname, a.…

php sql doctrine-orm symfony dql

Complex WHERE clauses using the PHP Doctrine ORM

I'm using the PHP Doctrine ORM to build my queries. However, I can't quite seem to figure how to write …

php mysql doctrine dql

Selecting from subquery in DQL

I would like to perform a SELECT from the results of a subquery in DQL. The equivalent of doing the …

doctrine symfony dql

How can I use now() in Doctrine 2 DQL?

$ php app/console doctrine:query:dql 'SELECT NOW()' [Doctrine\ORM\Query\QueryException] [Syntax Error] line 0, col 7: Error: Expected known …

mysql symfony doctrine-orm dql

Symfony form query_buider and entity repository

I'm trying to create a form with data in collection type depending on the user being logged. I'm following this …

symfony symfony-forms dql query-builder

Select One column Doctrine DQL

I need a simple column for a table. By example a table "project", with column id, name and year. If …

php doctrine dql doctrine-1.2

Doctrine DQL Date as parameter problem

Hi there I got a DQL that works (I get all my event since the beginning) : DoctrineHelper::getEntityManager()->…

php mysql doctrine-orm dql

doctrine2 dql, use setParameter with % wildcard when doing a like comparison

I want to use the parameter place holder - e.g. ?1 - with the % wild cards. that is, something like: "…

doctrine-orm wildcard dql sql-like code-injection

How can get unique values from data table using dql?

I am having a table in which there is a column in which various values are stored.i want to …

mysql doctrine dql

Query Builder / DQL not working with INNER JOIN - Syntax Issue

I know I have a syntax isse here however I cant figure it out. I'm trying to do a SELECT …

doctrine symfony inner-join dql query-builder