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/
_______________________________________________
Phpgroupware-tracker mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/phpgroupware-tracker
