A community in which webmasters can ask for help with topics such as PHP coding , MySQL , IT jobs, web design, IT security.
Current location:homephp forumphp talk in 2008 yearOuter Join using Propel 1.2? - page 1
User InfoPosts
Outer Join using Propel 1.2?#1
I'm trying to do an Outer Join in Symfony. Here's the bit of code that seems like it would work if Criteria supported OUTER_JOIN:

$user = sfContext::getInstance()->getUser();
$petCriteria = new Criteria();
$petCriteria->add(PetInfoPeer::ACCOUNT_ID, $user->getProfile()->getAccountId());
$petCriteria->add(LostPetPeer::PET_INFO_ID, Criteria::ISNULL);
$petCriteria->addJoin(LostPetPeer::PET_INFO_ID, PetInfoPeer::PET_INFO_ID, Criteria::OUTER_JOIN);

Am I missing something? Does Propel 1.3 support it? I've searched everywhere and have only found pseudo code.

posted date: 2008-12-15 16:11:00

Re: Outer Join using Propel 1.2?#2
I had made out the solution of this problem. click to view my topic...

hope that hepls.

posted date: 2008-12-15 16:11:01

Re: Outer Join using Propel 1.2?#3
I don't think this is possible using criteria. You'd have to write and run the SQL, then build the models, yourself.Here's a good example of that, found on this site.

posted date: 2008-12-16 10:18:00

Re: Outer Join using Propel 1.2?#4
I've confirmed this via IRC #symfony.

posted date: 2008-12-20 08:37:00

select page: « 1 »
Copyright ©2008-2017 www.momige.com, all rights reserved.