This is an old revision of the document!

fetchField

Syntax

  obj fetchField() {
      optional integer $fieldNumber
  }

Description

fetchField() returns database specific information about n^th column in a row of a recordset. Column offsets start at zero. If no field number is provided, the first column is returned.

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.

Usage

/*
 * Using IBM DB2 driver
 */
$SQL = "SELECT * FROM act";
$f = $conn->Execute($SQL);
/*
 * Offset 1
 */
$fld = $f->FetchField(1);
print_r($fld);
/*
 * Returns the following information
 *ADOFieldObject Object
 (
    [name] => ACTKWD
    [max_length] => 6
    [type] => string
 )

Explanation Of Common Fields

There are 3 common columns provided

Name	Description	Note
NAME	The column name	Casing of the column name is controlled by the 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 metaType() method, to obtain a cross-platform identifier