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

[Sigurd Nes]

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

Hi Philipp,

1) I more think of this as configuring adodb,
http://rush3d.com/reference/adodb-4.50/reference.varibles.adodb_fetch_mode.html

if ADODB_FETCH_DEFAULT is set to '0' 
the fieldnames is not defined in the resultSet from the adodb_mssql Object:

            [fields] => Array
                (
                    [0] => 1
                    [1] => phpgwapi
                    [2] => 3
                    [3] => 1
                    [4] => phpgw_config,....
                    [5] => 0.9.17.500
                )

ADODB_FETCH_DEFAULT set to '3'

gives

            [fields] => Array
                (
                    [0] => 1
                    [app_id] => 1
                    [1] => phpgwapi
                    [app_name] => phpgwapi
                    [2] => 3
                    [app_enabled] => 3
                    [3] => 1
                    [app_order] => 1
                    [4] => phpgw_config,...
                    [app_tables] => phpgw_config,...
                    [5] => 0.9.17.500
                    [app_version] => 0.9.17.500
                )


5)echo $GLOBALS['phpgw']->adodb->ErrorNo();
gives 0

echo $GLOBALS['phpgw']->adodb->ErrorMsg();
gives "Changed database context to '<databasename>'."
This is not an error message: mssql and sybase generates the warning whenever
you change (connect to) databases

Regards

Sigurd

    _______________________________________________________

Reply to this item at:

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

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