[Phpgroupware-cvs] CVS: phpgwapi/inc class.categories.inc.php,1.80,1.81

[Mark A Peters <address@hidden>]

Update of /cvsroot/phpgroupware/phpgwapi/inc
In directory subversions:/tmp/cvs-serv9536/phpgwapi/inc

Modified Files:
        class.categories.inc.php 
Log Message:
Fix for mssql or ODBC support.

Index: class.categories.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/phpgwapi/inc/class.categories.inc.php,v
retrieving revision 1.80
retrieving revision 1.81
diff -C2 -r1.80 -r1.81
*** class.categories.inc.php    4 Apr 2002 20:52:04 -0000       1.80
--- class.categories.inc.php    14 Apr 2002 03:27:50 -0000      1.81
***************
*** 496,502 ****
                        if (!$cat_values['parent'] || $cat_values['parent'] == 
0)
                        {
!                               $this->db->query("SELECT MAX(cat_id) AS max 
FROM phpgw_categories",__LINE__,__FILE__);
                                $this->db->next_record();
!                               $max = $this->db->f('max');
                                $this->db->query("UPDATE phpgw_categories SET 
cat_main='" . $max . "' WHERE cat_id='"
                                        . $max . "'",__LINE__,__FILE__);
--- 496,502 ----
                        if (!$cat_values['parent'] || $cat_values['parent'] == 
0)
                        {
!                               $this->db->query("SELECT MAX(cat_id) FROM 
phpgw_categories",__LINE__,__FILE__);
                                $this->db->next_record();
!                               $max = $this->db->f(0);
                                $this->db->query("UPDATE phpgw_categories SET 
cat_main='" . $max . "' WHERE cat_id='"
                                        . $max . "'",__LINE__,__FILE__);