php man page for ifx_fieldproperties

Query: ifx_fieldproperties

OS: php

Section: 3

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

IFX_FIELDPROPERTIES(3)							 1						    IFX_FIELDPROPERTIES(3)

ifx_fieldproperties - List of SQL fieldproperties

SYNOPSIS
array ifx_fieldproperties (resource $result_id)
DESCRIPTION
Returns the Informix SQL fieldproperties of every field in the query as an associative array. Properties are encoded as: "SQL- TYPE;length;precision;scale;ISNULLABLE" where SQLTYPE = the Informix type like "SQLVCHAR" etc. and ISNULLABLE = "Y" or "N".
PARAMETERS
o $result_id -$result_id is a valid resultid returned by ifx_query(3) or ifx_prepare(3) (select type queries only!).
RETURN VALUES
Returns an associative array with fieldnames as key and the SQL fieldproperties as data for a query with $result_id. Returns FALSE on errors.
EXAMPLES
Example #1 Informix SQL fieldproperties <?php $properties = ifx_fieldproperties($resultid); if (!isset($properties)) { /* ... error ... */ } foreach ($properties as $fname => $val) { echo "$fname: property = $val "; } ?>
SEE ALSO
ifx_fieldtypes(3). PHP Documentation Group IFX_FIELDPROPERTIES(3)
Related Man Pages
sqlsrv_client_info(3) - php
ifx_affected_rows(3) - php
ifx_fieldproperties(3) - php
ifx_getsqlca(3) - php
odbc_execute(3) - php
Similar Topics in the Unix Linux Community
Perl Programming for Splitting
SQL output vertically aligned?
Storing the SQL results in array variables
Convert MS Access Queries to AIX SQL
Join 2 SQL queries into one