DataObjects/core.sql

[Pman.Core] / DataObjects / Companies.php

diff --git a/DataObjects/Companies.php b/DataObjects/Companies.php
index 17bfd46..fb03111 100644 (file)
--- a/DataObjects/Companies.php
+++ b/DataObjects/Companies.php
@@ -86,9 +86,17 @@ class Pman_Core_DataObjects_Companies extends DB_DataObject
             
             
         }
-        
+        // ADD comptype_display name.. = for combos..
         $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
+                LIMIT 1
+                ) as comptype_display_name
         ");