For Adobe ColdFusion application servers mySQL Extension Pack

The mySQL Extension Pack contains a set of datatypes that correspond to data types available within mySQL. Note that you can successfully use the standard TerraForm datatypes with mySQL, but these may prove useful. If a field in your database uses the mySQL TinyInt data type, for example, you can simply specify myTinyInt as the datatype within a field of your form and be sure that TerraForm will make sure that only TinyInt-size data gets by! All the datatypes in this Pack are prefixed with "my" to avoid conflicting with predefined datatypes and datatypes from other packes.

To use this datatype pack, open customtags/terraform/settings.cfm and find section 5. Remove the comment tags from the following line:

<!--- <cfinclude template="datatypes/mysql.cfm"> --->

Examples

myBigInt

An integer between -9223372036854775808 and 9223372036854775807.

<cf_terrafield
  name="myBigInt"
  datatype="myBigInt"
/>

myBigInt_unsigned

An integer between 0 and 18446744073709551615.

<cf_terrafield
  name="myBigInt_unsigned"
  datatype="myBigInt_unsigned"
/>

myBIT | myBOOL

A binary digit (0 or 1).

<cf_terrafield
  name="myBIT"
  datatype="myBIT"
/>

myBlob

A string of maximum length 65535 characters.

<cf_terrafield
  name="myBlob"
  datatype="myBlob"
/>

myChar

A string of maximum length 255 characters.

<cf_terrafield
  name="myChar"
  datatype="myChar"
/>

myDate

A date value between 1 January 1000 and 31 December 9999.

<cf_terrafield
  name="myDate"
  datatype="myDate"
/>

myDateTime

A date/time value between 1 January 1753 00:00:00 and 31 December 9999 23:59:59.

<cf_terrafield
  name="myDateTime"
  datatype="myDateTime"
/>

[This list is incomplete at this stage.]


No comments yet