[Top][All Lists]
[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/