Differences

This shows you the differences between two versions of the page.

--- v5:userguide:learn_fields:associative_key_case [2016/03/18 02:16] – mnewnham
+++ v5:userguide:learn_fields:associative_key_case [2019/05/08 13:33] – Reduce duplicated info with ADODB_ASSOC_PAGE reference dregad
@@ Line 7: / Line 7: @@
 The constant must be defined //**before**// the inclusion of the ADOdb libraries
-There are 3 possible values:
+There are 3 possible values: ''ADODB_ASSOC_CASE_LOWER'', ''ADODB_ASSOC_CASE_UPPER'' and ''ADODB_ASSOC_CASE_NATIVE'' (Default). Note that use of native case is not recommended when writing portable applications.
-===== Constants =====
+See [[v5:reference:adodb_assoc_case#usage|ADODB_ASSOC_CASE reference]] for further information and usage examples.
-^Name^Value^Description^
-|ADODB_ASSOC_CASE_LOWER|0|lowercase field names|
-|ADODB_ASSOC_CASE_UPPER|1|uppercase field names|
-|ADODB_ASSOC_CASE_NATIVE (Default)|2|use native-case field names|
-<code php>
-DEFINE(ADODB_ASSOC_CASE,0);
-require "adodb/adodb.inc.php";
-$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
-$sql = 'select * from some_table';
-print_r($db->getAll($sql));
-/*
-* Returns
-*
-array(0=>array('col0'=>'val0',
-               'col1'=>'val1',
-               'col2'=>'val2',
-               etc....
-               )
-*/
-</code>
-If we now set the value of ADODB_ASSOC_CASE to upper case, we obtain the following effect:
-<code php>
-DEFINE(ADODB_ASSOC_CASE,1);
-require "adodb/adodb.inc.php";
-$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
-$sql = 'select * from some_table';
-print_r($db->getAll($sql));
-/*
-* Returns
-*
-array(0=>array('COL0'=>'val0',
-               'COL1'=>'val1',
-               'COL2'=>'val2',
-               etc....
-               )
-*/
-</code>
-  * Note that setting the value of this variable has no effect on the casing of the values of the array
-  * Use of **//ADODB_CASE_NATIVE//** is not recommended when writing portable applications, as there is no consistent casing across databases. Some DBMS may returned mixed-case keys.
-  *