[Fmsystem-commits] [11095] rental: fix pagination

[Sigurd Nes]

Revision: 11095
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=11095
Author:   sigurdne
Date:     2013-05-08 12:25:57 +0000 (Wed, 08 May 2013)
Log Message:
-----------
rental: fix pagination

Modified Paths:
--------------
    trunk/rental/inc/class.bofellesdata.inc.php

Modified: trunk/rental/inc/class.bofellesdata.inc.php
===================================================================
--- trunk/rental/inc/class.bofellesdata.inc.php 2013-05-07 08:14:01 UTC (rev 
11094)
+++ trunk/rental/inc/class.bofellesdata.inc.php 2013-05-08 12:25:57 UTC (rev 
11095)
@@ -459,7 +459,7 @@
                {
                        $this->log(__class__, __function__);
 
-                       $columns = "count(*)";
+                       $columns = "count(*) as COUNT";
                        $tables = "V_ORG_ENHET";
                        $joins =        "LEFT JOIN V_ORG_PERSON_ENHET ON 
(V_ORG_ENHET.ORG_ENHET_ID = V_ORG_PERSON_ENHET.ORG_ENHET_ID AND 
V_ORG_PERSON_ENHET.prioritet = 1) ".
                                                "LEFT JOIN V_ORG_PERSON ON 
(V_ORG_PERSON.ORG_PERSON_ID = V_ORG_PERSON_ENHET.ORG_PERSON_ID)";
@@ -500,7 +500,7 @@
                        
                        if($db->next_record())
                        {
-                               return $db->f('count');
+                               return $db->f('COUNT');
                        }
                        return 0;
                }