| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.2.3 |
| Request #3842 | Inner/outter join | ||
|---|---|---|---|
| Submitted: | 2005-03-16 13:38 UTC | ||
| From: | fabio at bs2 dot com dot br | Assigned: | quipo |
| Status: | Closed | Package: | MDB_QueryTool |
| PHP Version: | Irrelevant | OS: | |
| Roadmaps: | (Not assigned) | ||
[2005-03-16 13:38 UTC] fabio at bs2 dot com dot br
Description:
------------
in MDB_QueryTool when class build the select, the function don't build with an inner/outer join, why?
Comments
[2005-03-17 18:12 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2005-03-18 11:39 UTC] fabio at bs2 dot com dot br
I'm trying to use inner join on a select
$obj->setJoin(...); // here I dont have problem
but in
$res = $obj->get/getAll/getCol...(...);// result unexpected
$obj->getQueryString();//get the select query without inner Join
[2005-03-18 15:09 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2005-03-18 20:19 UTC] fabio at bs2 dot com dot br
the function getJoin don't return inner/outer join.
[2005-03-26 14:35 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2005-04-21 13:32 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2005-04-22 14:10 UTC] fabio at bs2 dot com dot br
don't working all rigth with me
$qt = &new MDB_QueryTool($dsn);
$qt->setTable('bug');
$qt->setJoin('bug_host' ,'fk_host = id_host' ,'inner');
$qt->getAll();
var_dump($qt->getQueryString()); //in this line the query returned is without inner join
[2005-04-22 14:38 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2005-04-22 15:02 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!