Symfony2 , doctrine custom query [duplicate]

Question

Possible Duplicate:
Symfony2 & Doctrine: Create custom SQL-Query

I tried that on my symfony2 project :

$em = $this->getDoctrine()->getEntityManager();
$query = $em->createQuery(
        'SELECT v.voiture,o.offre,m.marque
         FROM FrontOfficeBundle:Voiture v
         INNER JOIN FrontOfficeBundle:OffreSpecial o on o.voiture_id = v.id
         INNER JOIN FrontOfficeBundle:Marque m on m.id = v.marque_id'
    );
$result = $query->getResult();

and get that erreur :

[Syntax Error] line 0, col 122: Error: Expected Doctrine\ORM\Query\Lexer::T_WITH, got 'on'

even the SQL query are correcte ! plz help

Mick · Accepted Answer · 2013-02-11 00:50:51Z

1

You don't need the ON option for your INNER JOIN. The Doctrine Query Language already knows the mapping of your associations because you specified the class FrontOfficeBundle:Voiture in your query.

$em = $this->getDoctrine()->getEntityManager();
$query = $em->createQuery(
        'SELECT v.voiture,o.offre,m.marque
         FROM FrontOfficeBundle:Voiture v
         INNER JOIN v.offreSpecial o 
         INNER JOIN v.marque m'
    );
$result = $query->getResult();

edited Feb 11, 2013 at 0:50

answered Feb 4, 2013 at 1:16

Mick

32.2k17 gold badges114 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Symfony2 , doctrine custom query [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related