[Phpgroupware-cvs] tts index.php,1.52

[fipsfuchs]

Update of tts

Modified Files:
     Branch: MAIN
            index.php lines: +3 -3

Log Message:
fixed sql statement for postgre

====================================================
Index: tts/index.php
diff -u tts/index.php:1.51 tts/index.php:1.52
--- tts/index.php:1.51  Tue Jan 11 14:59:43 2005
+++ tts/index.php       Tue Mar 22 09:35:38 2005
@@ -106,7 +106,7 @@
        if($_REQUEST['ticket']['filter_status'] != 'none')
        {
                $sqlvalue = $_REQUEST['ticket']['filter_status'] == 'open' ? 
'O' : 'X'; // lol, nice value for sql
-               $filterstring .= 'ticket_status="'.$sqlvalue.'" AND ';
+               $filterstring .= "ticket_status='".$sqlvalue."' AND ";
        }
        if ($_REQUEST['searchfilter'] != '')
        {
@@ -122,7 +122,7 @@
        $GLOBALS['phpgw']->db->next_record();
        $numtotal = $GLOBALS['phpgw']->db->f('0') ;

-       $GLOBALS['phpgw']->db->query("select count(*) from phpgw_tts_tickets 
where ticket_status='O'",__LINE__,__FILE__);
+       $GLOBALS['phpgw']->db->query("select count(*) FROM phpgw_tts_tickets 
WHERE ticket_status='O'",__LINE__,__FILE__);
        $GLOBALS['phpgw']->db->next_record();
        $numopen = $GLOBALS['phpgw']->db->f('0') ;