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 >
	Oracle Miscellaneous Reference Copyright (c) 2013, Oracle and/or its affiliates. All rights reserved.