writing Joins using DB_DataObject 1.7.10

From: Date: Sat, 19 Mar 2005 14:09:39 +0000
Subject: writing Joins using DB_DataObject 1.7.10
Groups: php.pear.general 
Request: Send a blank email to pear-general+get-18150@lists.php.net to get a copy of this message
hello, i am working on DB_DataObject 1.7.10. i have few querries on writing joins: 1. How can i write "left outer joins" using DB_DataObjects? i found out that addjoin has only 3 options "LEFT, RIGHT AND INNER".. 2. If i want to write condition in ON clause of JOIN, i use the follwing method: $this->joinAdd($location); $this->whereAdd($this->id = $location->id); this works fine. but if i want to write multiple condition in ON clause for example: $this->joinAdd($location); $this->whereAdd($this->id = $location->id AND $location->state = 1); then only first condition is considered.. second is ignored.. please help me if anyone has worked on the problem.. thanking you regards kurund jalmi

« previous php.pear.general (#18150) next »