Home > Contents > Index >
AssetMaker   |    Cart Tags   |    Errors   |    Miscellany   |    Index

 

Restrictions and Dependencies with TYPE

The possible settings for your INPUTFORM TYPE and SEARCHFORM TYPE parameters are dependent on the data type you set for STORAGE TYPE. For example, you can set INPUTFORM TYPE to UPLOAD only when you set your STORAGE TYPE to VARCHAR.

This section describes the dependencies, restrictions, and issues associated with the two TYPES, based on the data type specified for STORAGE TYPE.

CHAR (STORAGE TYPE="CHAR")

INPUTFORM and
SEARCHFORM TYPE
INPUTFORM issues
SEARCHFORM issues
    TEXT
    
none
The search in the field uses the SQL verb "LIKE" when building its query.
    TEXTAREA
    
If the field is a URL field (PROPERTY NAME begins with the letters "url"), the data type cannot be CHAR, it must be VARCHAR.
The search in the field uses the SQL verb "LIKE" when building its query.

    UPLOAD
    
You cannot create an upload field if the data type is CHAR. You can create an upload field only if the data type is VARCHAR.
not applicable
    SELECT
    
If multiple values are legal, they are concatenated into a delimited list when they are saved to the database.
Be sure to set the field length large enough to store all of the values in the concatenated list, including the delimiters.
If the values come from a table ("SOURCETYPE=TABLE") the datatype for the column containing the key for that table should be VARCHAR or CHAR.
You cannot include a select field that accepts multiple values on the Advanced Search form.
The search in the field uses the SQL verb "LIKE" by default when building its query. You may override this by specifying "VERB".
    CHECKBOXES
    
If the values come from a table ("SOURCETYPE=TABLE") the datatype for the column containing the key for that table should be VARCHAR or CHAR.
You cannot include check boxes in the Advanced Search form.
    RADIO
    
If the values come from a table ("SOURCETYPE=TABLE") the datatype for the column containing the key for that table should be VARCHAR or CHAR.
The search in the field uses the SQL verb "LIKE" when building its query.
    EWEBEDITPRO
    
You cannot create an eWebEditPro field if the data type is CHAR. You can create an eWebEditPro field only if the data type is VARCHAR.
not applicable

 

VARCHAR (STORAGE TYPE="VARCHAR")

INPUTFORM and
SEARCHFORM TYPE
INPUTFORM issues
SEARCHFORM issues
    TEXT
    
If the field is a URL field (PROPERTY NAME begins with the letters "url"), the INPUTFORM type cannot be TEXT. TEXTAREA or UPLOAD can be used.
The search in the field uses the SQL verb "LIKE" as the default when building its query, you may also specify "VERB".
    TEXTAREA
    
none
The search in the field uses the SQL verb "LIKE" as the default when building its query, you may also specify "VERB".
    UPLOAD
    
UPLOAD is available only with the VARCHAR data type.
You cannot include upload fields in the Advanced Search form.
    SELECT
    
If multiple values are legal, they are concatenated into a delimited list when they are saved to the database.
Be sure to set the field length large enough to store all of the values in the concatenated list, including the delimiters.
If the values come from a table ("SOURCETYPE=TABLE") the datatype for the column containing the key for that table should be VARCHAR or CHAR.
You cannot include a select field that accepts multiple values on the Advanced Search form.
The search in the field uses the SQL verb "LIKE" when building its query.

    CHECKBOX
    
If multiple values are legal, they are concatenated into a delimited list when they are saved to the database.
Be sure to set the field length large enough to store all of the values in the concatenated list, including the delimiters.
If the values come from a table ("SOURCETYPE=TABLE") the datatype for the column containing the key for that table should be VARCHAR or CHAR.
You cannot include check boxes in the Advanced Search form.
    RADIO
    
If the values come from a table ("SOURCETYPE=TABLE") the datatype for the column containing the key for that table should be VARCHAR or CHAR.
The search in the field uses the SQL verb "LIKE" when building its query.
    EWEBEDITPRO
    
You cannot create an eWebEditPro field if the data type is CHAR. You can create an eWebEditPro field only if the data type is VARCHAR.
not applicable

 

SMALLINT

INPUTFORM and
SEARCHFORM TYPE
INPUTFORM issues
SEARCHFORM issues
    TEXT
    
none
You must set the VERB attribute. See SEARCHFORM.
    TEXTAREA
    
Not a good choice for a SMALLINT data type.
Additionally, if the field is a URL field (PROPERTY NAME begins with the letters "url"), the data type cannot be SMALLINT, it must be VARCHAR.

You must set the VERB attribute. See SEARCHFORM.
    UPLOAD
    
You cannot create an upload field if the data type is SMALLINT. You can only create an upload field if the data type is VARCHAR.
not applicable
    SELECT
    
You cannot create a field that holds multiple values if the data type is SMALLINT.
You must set the VERB attribute. See SEARCHFORM.
    CHECKBOX
    
You cannot create a field that holds multiple values if the data type is SMALLINT.
You must set the VERB attribute. See SEARCHFORM.
    RADIO
    
none
You must set the VERB attribute. See SEARCHFORM.
    EWEBEDITPRO
    
You cannot create an eWebEditPro field if the data type is SMALLINT. You can create an eWebEditPro field only if the data type is VARCHAR.
not applicable

 

INTEGER (STORAGE TYPE="INTEGER")

INPUTFORM and
SEARCHFORM TYPE
INPUTFORM issues
SEARCHFORM issues
    TEXT
    
none
You must set the VERB attribute. See SEARCHFORM.
    TEXTAREA
    
Not a good choice for an INTEGER data type.
Additionally, if the field is a URL field (PROPERTY NAME begins with the letters "url"), the data type cannot be INTEGER, it must be VARCHAR.
You must set the VERB attribute. See SEARCHFORM.
    UPLOAD
    
You cannot create an upload field if the data type is INTEGER. You can only create an upload field if the data type is VARCHAR.

Not applicable.
    SELECT
    
You cannot create a field that holds multiple values if the data type is INTEGER.
You must set the VERB attribute. See SEARCHFORM.
    CHECKBOX
    
You cannot create a field that holds multiple values if the data type is INTEGER.
You must set the VERB attribute. See SEARCHFORM.
    RADIO
    
none
You must set the VERB attribute. See SEARCHFORM.
    EWEBEDITPRO
    
You cannot create an eWebEditPro field if the data type is INTEGER. You can create an eWebEditPro field only if the data type is VARCHAR.
not applicable

 

BIGINT (STORAGE TYPE="BIGINT")

INPUTFORM and
SEARCHFORM TYPE
INPUTFORM issues
SEARCHFORM issues
    TEXT
    
none
You must set the VERB attribute. See SEARCHFORM.
    TEXTAREA
    
Not a good choice for a BIGINT data type.
You must set the VERB attribute. See SEARCHFORM.
    UPLOAD
    
You cannot create an upload field if the data type is BIGINT. You can only create an upload field if the data type is VARCHAR.
not applicable
    SELECT
    
You cannot create a field that holds multiple values if the data type is BIGINT.
You must set the VERB attribute. See SEARCHFORM.
    CHECKBOX
    
You cannot create a field that holds multiple values if the data type is BIGINT.
You must set the VERB attribute. See SEARCHFORM.
    RADIO
    
none
You must set the VERB attribute. See SEARCHFORM.
    EWEBEDITPRO
    
You cannot create an eWebEditPro field if the data type is BIGINT. You can create an eWebEditPro field only if the data type is VARCHAR.
not applicable

 

DOUBLE (STORAGE TYPE="DOUBLE")

INPUTFORM and
SEARCHFORM TYPE
INPUTFORM issues
SEARCHFORM issues
    TEXT
    
none
You must set the VERB attribute. See SEARCHFORM.
    TEXTAREA
    
Not a good choice for the DOUBLE data type.
Additionally, if the field is a URL field (PROPERTY NAME begins with the letters "url"), the data type cannot be DOUBLE, it must be VARCHAR.
You must set the VERB attribute. See SEARCHFORM.
    UPLOAD
    
You cannot create an upload field if the data type is DOUBLE. You can only create an upload field if the data type is VARCHAR.
You must set the VERB attribute. See SEARCHFORM.
    SELECT
    
You cannot create a field that holds multiple values if the data type is DOUBLE.
You must set the VERB attribute. See SEARCHFORM.
    CHECKBOX
    
You cannot create a field that holds multiple values if the data type is DOUBLE.
You must set the VERB attribute. See SEARCHFORM.
    RADIO
    
none
You must set the VERB attribute. See SEARCHFORM.
    EWEBEDITPRO
    
You cannot create an eWebEditPro field if the data type is DOUBLE. You can create an eWebEditPro field only if the data type is VARCHAR.
not applicable

 

TIMESTAMP (STORAGE TYPE="TIMESTAMP")

INPUTFORM and
SEARCHFORM TYPE
INPUTFORM issues
SEARCHFORM issues
    TEXT
    
none
You must set the VERB attribute. See SEARCHFORM.
    TEXTAREA
    
Not a good choice for a TIMESTAMP data type.
Additionally, if the field is a URL field (PROPERTY NAME begins with the letters "url"), the data type cannot be TIMESTAMP, it must be VARCHAR.
You must set the VERB attribute. See SEARCHFORM.
    UPLOAD
    
You cannot create an upload field if the data type is TIMESTAMP. You can only create an upload field if the data type is VARCHAR.
not applicable
    SELECT
    
Not a good choice for a TIMESTAMP data type.
You must set the VERB attribute. See SEARCHFORM.
    CHECKBOX
    
Not a good choice for a TIMESTAMP data type.
You must set the VERB attribute. See SEARCHFORM.
    RADIO
    
Not a good choice for a TIMESTAMP data type.
You must set the VERB attribute. See SEARCHFORM.
    EWEBEDITPRO
    
You cannot create an eWebEditPro field if the data type is TIMESTAMP. You can create an eWebEditPro field only if the data type is VARCHAR.
not applicable

 

  Home > Contents > Index >

FatWire Miscellaneous Reference
Copyright 2005 by FatWire Software
All rights reserved.