But not with pager. Im trying to perform a join like so:
SELECT * FROM gallery_media
LEFT JOIN media ON (gallery_media.MEDIA_ID=media.ID)
LEFT JOIN media_tag ON (media.ID=media_tag.MEDIA_ID)
LEFT JOIN tag ON (media_tag.TAG_ID=tag.ID)
WHERE gallery_media.GALLERY_ID=$id
I wrote that myself to make sure it even generated results and it does. I
then ran BasePeer::createSelectSql() on my criteria object to make sure it
was producing the query I wanted, and it is. So then I used
sfPropelCustomJoinHelper::doSelectRS() and it gets the rs fine. the issue is
somewher in hydarting objects (as the error in my browser tells me) at line
52 where theres an addExternalObject call:
[code]
foreach ($childObjs as $childClassName => $childObj)
{
$obj->addExternalObject($childObj, $childClassName); //main class
object always holds all child objects.
if (isset($this->classOwnership[$childClassName]))
/* line 52 */ foreach ($this->classOwnership[$childClassName] as $tmp)
if (array_key_exists($tmp[0], $childObjs))
$childObj->addExternalObject($childObjs[$tmp[0]], $tmp[1]);
}
[/code]
heres what my code looks like:
[code]
$c = new Criteria();
$c->addAnd(GalleryMediaPeer::GALLERY_ID,$id);
$c->addJoin(GalleryMediaPeer::MEDIA_ID, MediaPeer::ID,
Criteria::LEFT_JOIN)->addJoin(MediaPeer::ID, MediaTagPeer::MEDIA_ID,
Criteria::LEFT_JOIN)->addJoin(MediaTagPeer::TAG_ID, TagPeer::ID,
Criteria::LEFT_JOIN);
$j = new sfPropelCustomJoinHelper('GalleryMedia');
$j->addSelectTables('GalleryMedia', 'Gallery', 'Media', 'MediaTag',
'Tag');
$j->setHas('GalleryMedia', 'Gallery');
$j->setHas('GalleryMedia', 'Media');
$j->setHas('Media', 'MediaTag');
$j->setHas('MediaTag', 'Tag');
return $j->doSelectRS($c);
[/code]
Im examinig the class right now to try and trace whats happening but if
anyone has had similar issues or has any insights that might help me get to
a quicker resolution that would be most appreciated.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
