writing Joins using DB_DataObject 1.7.10
| From: | Kurund Jalmi | 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