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.
