Differences

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

--- v5:userguide:learn_fields:field_objects [2016/03/20 16:49] – [MetaType Based Decisions] mnewnham
+++ v5:userguide:learn_fields:field_objects [2021/03/09 09:38] (current) – [Interrogating The Columns] wrong variable name in code sample dregad
@@ Line 2: / Line 2: @@
 ~~NOTOC~~
 ====== Fields As Objects ======
-In Lesson 2, the concept of the **//ActualTypes//** was explained. In this section, we show how the value of field, and also the attributes of the same field can be obtained. By treating the returned result set as a 2 dimensional array, we can process each row on a column-by-column basis.
+In Lesson 2, the concept of the **//ActualTypes//** was explained.
+In this section, we show how the value of a field, as well as its attributes, can be obtained.
+By treating the returned result set as a 2 dimensional array, we can process each row on a column-by-column basis.
 ===== The Limits Of The Array =====
@@ Line 13: / Line 15: @@
 ===== Walking The Rows Of A ResultSet =====
-In Lesson 1, we saw a number of ways of moving from one row to the next. It is important to not mix methods, as some methods read the record and automatically advance the record pointer, and some do not. However in all cases, a flag **EOF** is set as soon as the end of the result set is reached. In the following example, the method [[v5:reference:connection:movenext|moveNext()]] is used.
+In Lesson 1, we saw a number of ways of moving from one row to the next. It is important to not mix methods, as some methods read the record and automatically advance the record pointer, and some do not. However in all cases, a flag **EOF** is set as soon as the end of the result set is reached. In the following example, the method [[v5:reference:recordset:movenext|moveNext()]] is used.
 Note the for both rows and columns, ADOdb uses the PHP convention of a Zero-Based (0) array, as opposed to SQL offsets, which are One-based (1).
@@ Line 49: / Line 51: @@
          */
          $fieldInfo = $recordSet->fetchField($colIndex);
-         $type      = $recordSet->metaType($fld->type);
+         $type      = $recordSet->metaType($fieldInfo->type);
          /*
          * This is the value of the field
          */
-         $value     = $recordSet->fields[$colIndex];
+         $value     = $recordSet->fields($colIndex);
 </code>
@@ Line 71: / Line 73: @@
      * End of the colums, move to next row
      */
-     $recordSet->MoveNext();
+     $recordSet->moveNext();
 }