diff options
| author | Michael Jennings <mej@users.sourceforge.net> | 2005-12-20 13:41:46 +0000 |
|---|---|---|
| committer | Michael Jennings <mej@users.sourceforge.net> | 2005-12-20 13:41:46 +0000 |
| commit | 8e3e35132a7ddd09a8b6d1e9f46cfb2f6ea2c43f (patch) | |
| tree | ac5185cc7b8139c07f20566c334f1f8ef879f4a1 /Pigeonholes.php | |
| parent | 9f7ab75616493dcf972fcca75300cc6a89fbd498 (diff) | |
| download | pigeonholes-8e3e35132a7ddd09a8b6d1e9f46cfb2f6ea2c43f.tar.gz pigeonholes-8e3e35132a7ddd09a8b6d1e9f46cfb2f6ea2c43f.tar.bz2 pigeonholes-8e3e35132a7ddd09a8b6d1e9f46cfb2f6ea2c43f.zip | |
Tue Dec 20 08:41:39 2005 Michael Jennings (mej)
Be specific about JOIN type.
----------------------------------------------------------------------
Diffstat (limited to 'Pigeonholes.php')
| -rw-r--r-- | Pigeonholes.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/Pigeonholes.php b/Pigeonholes.php index f2e5a2a..80d4625 100644 --- a/Pigeonholes.php +++ b/Pigeonholes.php @@ -1,6 +1,6 @@ <?php /** - * @version $Header: /cvsroot/bitweaver/_bit_pigeonholes/Pigeonholes.php,v 1.11 2005/11/22 20:29:24 bitweaver Exp $ + * @version $Header: /cvsroot/bitweaver/_bit_pigeonholes/Pigeonholes.php,v 1.12 2005/12/20 13:41:46 mej Exp $ * * +----------------------------------------------------------------------+ * | Copyright ( c ) 2004, bitweaver.org @@ -17,7 +17,7 @@ * Pigeonholes class * * @author xing <xing@synapse.plus.com> - * @version $Revision: 1.11 $ + * @version $Revision: 1.12 $ * @package pigeonholes */ @@ -250,7 +250,7 @@ class Pigeonholes extends LibertyAttachable { function getPigeonholesPathList( $pContentId=NULL ) { $query = "SELECT bp.`content_id`, bp.`structure_id` FROM `".BIT_DB_PREFIX."bit_pigeonholes` bp - JOIN `".BIT_DB_PREFIX."tiki_structures` ts ON ( ts.`structure_id` = bp.`structure_id` ) + INNER JOIN `".BIT_DB_PREFIX."tiki_structures` ts ON ( ts.`structure_id` = bp.`structure_id` ) ORDER BY ts.`root_structure_id`, ts.`structure_id` ASC"; $result = $this->mDb->query( $query ); $pigeonholes = $result->getRows(); |