Hello,
Check with this:
$q = Doctrine_Query::create()
->select('j.*, (j.endtime - j.starttime) as duration, s.jobstatuslong,
c.name, p.name, f.*')
->from('Job j')
->leftJoin('j.Status s')
->leftJoin('j.Client c')
->leftJoin('j.Pool p')
->leftJoin('j.Fileset f')
->where("j.endtime > ?", $last1day)
->addWhere("j.jobstatus IN ('T', 'E', 'e', 'f', 'A')")
->orderBy('j.starttime, j.jobid')
Bertrand
Le 20 juin 09 à 15:48, Reynier Pérez Mira a écrit :
> When I try to execute I get this error:
> 500 | Internal Server Error | Doctrine_Hydrator_Exception
> "Status" with an alias of "s" in your query does not reference the
> parent component it is related to.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
