SqlBuilder (OpenHMS) 2.0.1 (Default branch)

Tags

Special Forums News, Links, Events and Announcements Software Releases - RSS News SqlBuilder (OpenHMS) 2.0.1 (Default branch)

04-07-2008

Registered User

26,240, 27

Join Date: Sep 2000

Last Activity: 1 August 2008, 3:09 PM EDT

Posts: 26,240

Thanks Given: 0

Thanked 27 Times in 26 Posts

SqlBuilder (OpenHMS) 2.0.1 (Default branch)

SqlBuilder is a library that attempts to take the pain out of generating SQL queries within Java programs. It wraps the SQL syntax within very lightweight and easy to use Java objects that follow the "builder" paradigm (similar to StringBuilder). This changes many common SQL syntactical, runtime errors into Java compile-time errors. License: GNU Lesser General Public License (LGPL) Changes:
This release folds numeric conversions into normal value conversions.

More...

Linux Bot

View Public Profile for Linux Bot

Find all posts by Linux Bot

Previous Thread | Next Thread

LEARN ABOUT PHP

ifx_fieldproperties

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)