DataObjects/Companies.php

diff --git a/DataObjects/Companies.php b/DataObjects/Companies.php
index 17bfd46..5c2efd9 100644 (file)
--- a/DataObjects/Companies.php
+++ b/DataObjects/Companies.php
@@ -88,7 +88,14 @@ class Pman_Core_DataObjects_Companies extends DB_DataObject
         }
         
         $this->selectAdd("
-            (SELECT display_name from core_enum where etype='comptype' AND name={$tn}.comptype) as comptype_display_name
+            (SELECT display_name
+                FROM
+                    core_enum
+                WHERE
+                    etype='comptype'
+                    AND
+                    name={$tn}.comptype
+            ) as comptype_display_name
         ");