Differences

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

--- reference:fetchfield [2016/01/13 02:06] – ↷ Links adapted because of a move operation mnewnham
+++ v5:reference:recordset:fetchfield [2021/05/05 03:42] (current) – mnewnham
@@ Line 2: / Line 2: @@
 ~~NOTOC~~
 <WRAP right box>
+== See Also ==
+[[v5:reference:recordset:fieldTypesArray|fieldTypesArray()]]\\
 == Syntax ==
-    obj fetchField() {
+    mixed fetchField() {
         optional integer $fieldNumber
     }
@@ Line 9: / Line 12: @@
 ===== Description =====
 fetchField() returns __database specific__ information about n<sup>th</sup> column in a row of a recordset. Column offsets start at zero. If no field number is provided, the first column is returned.
+If the recordset is available and the offset provided is in range, then an **ADOFieldObject** object is returned, otherwise the method returns **false**.
 **It is important to note that the information contained in the object returned varies from database to database.** There is a common set of fields returned, but the values vary from database to database for the same data type. Check the guide for each driver to see any extra information provided.
@@ Line 39: / Line 45: @@
 There are 3 common columns provided
 ^ Name        ^ Description                                ^ Note                                                                                                                                                                                        ^
-| NAME        | The column name                            | Casing of the column name is controlled by the [[reference:ADODB_ASSOC_CASE]] constant.                                                                                                     |
+| NAME        | The column name                            | Casing of the column name is controlled by the [[v5:reference:adodb_assoc_case]] constant.                                                                                                     |
 | MAX_LENGTH  | The length of the field.                   | For CHAR type variables, this can represent the maximum character length, but for others, it can represent the number of bytes                                                              |
 | TYPE        | This is the database specific field type.  | If you are writing cross-database applications, do not rely on this value. Instead, send the value to the [[v5:dictionary:metatype|metaType()]] method, to obtain a cross-platform identifier  |