====== getRowAssoc ======
~~NOTOC~~
<WRAP alert>
Using this function when the fetch mode is set to ADODB_FETCH_ASSOC may produce unpredictable results
</WRAP>
<WRAP todo>
Currently, after the first call to getRowAssoc, any changes to ''$upperCase'' have no effect
</WRAP>

<WRAP right box>
== Syntax ==
  mixed getRowAssoc(
        optional bool $upperCase=true
        )
</WRAP>
===== Description =====
The function ''getRowAssoc()'' returns the current row of a recordset in associative mode if the recordset was originally fetched in numeric mode. The second parameter ''$upperCase'' indicates whether the keys of the recordset should be upper case or lower case. The constant [[v5:reference:adodb_assoc_case]] has no effect on the returned row keys.
--------------------------------------
===== Usage =====
<code php>
/* 
 * Database connection assumed
 */
$db->setFetchMode(ADODB_FETCH_NUM);
$SQL = "SELECT * FROM act";
$result = $db->execute($SQL);
$r = $result->fetchRow();
print_r($r);
/*
 * Prints 
Array
(
    [0] => 10
    [1] => MANAGE
    [2] => MANAGE/ADVISE
)


 */
$r = $result->getRowAssoc(false);
print_r($r);
/*
 * Prints
Array
(
    [actno] => 20
    [actkwd] => ECOST
    [actdesc] => ESTIMATE COST */
</code>

{{tag>[PEAR]}}