Can you provide the exact error message and even better, the
backtrace?
On Jul 25, 2:57 am, Ant Cunningham <[EMAIL PROTECTED]>
wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
