Revision: 18579
http://svn.sv.gnu.org/viewvc/?view=rev&root=phpgroupware&revision=18579
Author: maat
Date: 2008-06-02 10:09:52 +0000 (Mon, 02 Jun 2008)
Log Message:
-----------
fix: sql for list_all_versions in a project
Modified Paths:
--------------
trunk/ged/inc/class.ged_dm.inc.php
Modified: trunk/ged/inc/class.ged_dm.inc.php
===================================================================
--- trunk/ged/inc/class.ged_dm.inc.php 2008-06-02 09:57:50 UTC (rev 18578)
+++ trunk/ged/inc/class.ged_dm.inc.php 2008-06-02 10:09:52 UTC (rev 18579)
@@ -3463,9 +3463,9 @@
$sql="SELECT *, ged_elements.description edescription,
ged_versions.description vdescription, ";
$sql.="ged_versions.creation_date vcreation_date,
ged_elements.creator_id ecreator_id ";
$sql.="FROM ( ged_elements ";
- $sql.="JOIN ged_versions On ( ged_elements.element_id =
ged_versions.element_id) ";
- $sql.="LEFT JOIN ged_doc_types ON
ged_elements.project_root=".(int)$project_root_id." ";
- $sql.="AND ged_elements.doc_type = ged_doc_types.type_id ) ";
+ $sql.="JOIN ged_versions On ( ged_elements.element_id =
ged_versions.element_id " .
+ $sql.="AND ged_elements.project_root=".(int)$project_root_id."
) ";
+ $sql.="LEFT JOIN ged_doc_types ON ged_elements.doc_type =
ged_doc_types.type_id ) ";
$sql.="ORDER BY ged_elements.doc_type,
ged_elements.creation_date";
$this->db->query($sql, __LINE__, __FILE__);
_______________________________________________
phpGroupWare-cvs mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/phpgroupware-cvs
