phpgroupware-tracker
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Phpgroupware-tracker] [patch #3927] Patch to enable mssql with adodb


From: Philipp Kamps
Subject: [Phpgroupware-tracker] [patch #3927] Patch to enable mssql with adodb
Date: Mon, 2 May 2005 14:59:38 +0000
User-agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.6) Gecko/20050324 Debian/1.7.6-1

Follow-up Comment #5, patch #3927 (project phpgroupware):

Please see this code for example:


// read the tickets
        $sql = 'SELECT * FROM phpgw_tts_tickets '.
               'LEFT JOIN phpgw_tts_views ON (phpgw_tts_tickets.ticket_id =
phpgw_tts_views.view_id AND phpgw_tts_views.view_account_id =
'.$GLOBALS['phpgw_info']['user']['account_id'].') '.
               'WHERE '.$filterstring.$sortmethod;
        //echo $sql;
        $rs = $GLOBALS['phpgw']->db->adodb->Execute($sql);
        $alltickets = $rs->GetArray();

a _debug_array($alltickets) gives:


Array
(
    [0] => Array
        (
            [0] => 3
            [ticket_id] => 3
            [1] => 2
            [ticket_group] => 2
            [2] => 1
            [ticket_priority] => 1
            [3] => 6
            [ticket_owner] => 6
            [4] => 3
            [ticket_assignedto] => 3
            [5] => asdf
            [ticket_subject] => asdf
            [6] => 1
            [ticket_category] => 1
            [7] => 0.00
            [ticket_billable_hours] => 0.00
            [8] => 0.00
            [ticket_billable_rate] => 0.00
            [9] => O
            [ticket_status] => O
            [10] => asdf
            [ticket_details] => asdf
            [11] => 1
            [ticket_type] => 1
            [12] => 0--0
            [ticket_deadline] => 0--0
            [13] => 
            [ticket_effort] => 
            [14] => 1
            [ticket_platform] => 1
            [15] => 0
            [ticket_attachment] => 0
            [16] => 1115045643
            [ticket_lastmod] => 1115045643
            [17] => 
            [view_id] => 
            [18] => 
            [view_account_id] => 
            [19] => 
            [view_time] => 
        )

)

I don't have changed adodb's config.

Cheers, fips


    _______________________________________________________

Reply to this item at:

  <http://savannah.gnu.org/patch/?func=detailitem&item_id=3927>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/





reply via email to

[Prev in Thread] Current Thread [Next in Thread]