I believe this is exactly what you want:
http://groups.google.com/group/symfony-users/browse_thread/thread/40df48dd79cb274e?hl=en
It explains how to do custom propel joins, and custom hydrating so all
objects are created/filled with data.
Mark
On Jul 10, 10:01 pm, kusum <[EMAIL PROTECTED]> wrote:
> hi,
> i want to join three table in this format .and it is working
> properly,but it is giving only fields of listing table.and i want to
> get selected fields from all these three tables and i want to use
> object of listing table .In this format it is possible or not.and
> if it is possible than what will be the pattern of query.
>
> $c=new Criteria();
> $c->addJoin(BuilderProjectPeer::OWNER_ID, OwnerPeer::ID);
> $c->addJoin(ListingPeer::OWNER_ID,BuilderProjectPeer::OWNER_ID);
>
> $c->addJoin(ListingPeer::OWNER_ID,OwnerPeer::ID);
> $c->setLimit(5);
> $c->addAscendingOrderByColumn('RAND()');//line 47
> $checkrecord = ListingPeer::doSelect($c);
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
