Hi
Tables: Gig, Song and GigSong (many-to-many).
I use a pager and in executeIndex I set up the Query:
$q = Doctrine_Query::create()
->from('Gig g')
->leftJoin('g.GigSong gs ON gs.gig_id = g.id')
->orderBy('gs.order_id ASC');
$this->pager->setQuery($q);
...
On the indexSuccess page there will be a call $gig->getSongs() for
each gig.
class Gig ..
public function getSongs()
{
$q = Doctrine_Query::create()
->from('Song s')
->leftJoin('s.GigSong gs ON s.id = gs.song_id')
->andWhere('gs.gig_id = ?', $this->id)
->orderBy('gs.order_id ASC');
return $q->execute();
}
This results in 25 queries. How can I join the songs in the first
query?
In advance
comb
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
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
