Sorry, i was wrong i also have error with the getters when i have only one query...:)
So the question again: how do you merge the resulting objects of two queries? Javi On Dec 3, 3:28 pm, tirengarfio <[email protected]> wrote: > Hi, > > i have these two queries below and i want to merge the resulting > objects, but i can't. > > public static function getAmigos($id) > { > $q1 = Doctrine_Query::create() > ->from('Usuario u') > ->leftJoin('u.AmigoUsuario a ON u.id = a.user1') > ->where("a.user2 LIKE ?", $id) > ->andWhere("a.estado LIKE ?", 1) > ->execute(); > > $q2 = Doctrine_Query::create() > ->from('Usuario u') > ->leftJoin('u.AmigoUsuario a ON u.id = a.user2') > ->where("a.user1 LIKE ?", $id) > ->andWhere("a.estado LIKE ?", 1) > ->execute(); > > $array_q1 = $q1->toArray(); > > $array_q2 = $q2->toArray(); > > $q = array_merge($array_q1, $array_q2); > > return $q; > > } > > As you can see I have tried it with array_merge() but i get errors > with the getters because the resulting objects are not considered as > "objects" anymore. > > No problem if use only one query, i mean this: > > public static function getAmigos($id) > { > > $q1 = Doctrine_Query::create() > ->from('Usuario u') > ->leftJoin('u.AmigoUsuario a ON u.id = a.user1') > ->where("a.user2 LIKE ?", $id) > ->andWhere("a.estado LIKE ?", 1) > ->execute(); > > $array_q1 = $q1->toArray(); > > return $q1; > > } > > How would you do it? > > Bye > > Javi -- You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en.
