Home > Contents > Index >
AssetMaker | Cart Tags | Errors | Miscellany | Index
Restrictions and Dependencies with TYPE
The possible settings for your
INPUTFORM TYPE
andSEARCHFORM TYPE
parameters are dependent on the data type you set forSTORAGE TYPE
. For example, you can setINPUTFORM TYPE
toUPLOAD
only when you set yourSTORAGE TYPE
toVARCHAR
.This section describes the dependencies, restrictions, and issues associated with the two
TYPES
, based on the data type specified forSTORAGE
TYPE
.CHAR (STORAGE TYPE="CHAR")
INPUTFORM andSEARCHFORM 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 beCHAR
, it must beVARCHAR
. 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 isCHAR
. You can create an upload field only if the data type isVARCHAR
. 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 isCHAR
. You can create an eWebEditPro field only if the data type isVARCHAR
. not applicable
VARCHAR (STORAGE TYPE="VARCHAR")
INPUTFORM andSEARCHFORM 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". UPLOADUPLOAD
is available only with theVARCHAR
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 isCHAR
. You can create an eWebEditPro field only if the data type isVARCHAR
. not applicable
SMALLINT
INPUTFORM andSEARCHFORM TYPE INPUTFORM issues SEARCHFORM issues TEXT none You must set theVERB
attribute. See SEARCHFORM. TEXTAREA Not a good choice for aSMALLINT
data type.Additionally, if the field is a URL field (PROPERTY
NAME
begins with the letters "url"), the data type cannot beSMALLINT
, it must beVARCHAR
. You must set theVERB
attribute. See SEARCHFORM. UPLOAD You cannot create an upload field if the data type isSMALLINT
. You can only create an upload field if the data type isVARCHAR
. not applicable SELECT You cannot create a field that holds multiple values if the data type isSMALLINT
. You must set theVERB
attribute. See SEARCHFORM. CHECKBOX You cannot create a field that holds multiple values if the data type isSMALLINT
. You must set theVERB
attribute. See SEARCHFORM. RADIO none You must set theVERB
attribute. See SEARCHFORM. EWEBEDITPRO You cannot create an eWebEditPro field if the data type isSMALLINT
. You can create an eWebEditPro field only if the data type isVARCHAR
. not applicable
INTEGER (STORAGE TYPE="INTEGER")
INPUTFORM andSEARCHFORM TYPE INPUTFORM issues SEARCHFORM issues TEXT none You must set theVERB
attribute. See SEARCHFORM. TEXTAREA Not a good choice for anINTEGER
data type.Additionally, if the field is a URL field (PROPERTY
NAME
begins with the letters "url"), the data type cannot beINTEGER
, it must beVARCHAR
. You must set theVERB
attribute. See SEARCHFORM. UPLOAD You cannot create an upload field if the data type isINTEGER
. You can only create an upload field if the data type isVARCHAR
. Not applicable. SELECT You cannot create a field that holds multiple values if the data type isINTEGER
. You must set theVERB
attribute. See SEARCHFORM. CHECKBOX You cannot create a field that holds multiple values if the data type isINTEGER
. You must set theVERB
attribute. See SEARCHFORM. RADIO none You must set theVERB
attribute. See SEARCHFORM. EWEBEDITPRO You cannot create an eWebEditPro field if the data type isINTEGER
. You can create an eWebEditPro field only if the data type isVARCHAR
. not applicable
BIGINT (STORAGE TYPE="BIGINT")
INPUTFORM andSEARCHFORM TYPE INPUTFORM issues SEARCHFORM issues TEXT none You must set theVERB
attribute. See SEARCHFORM. TEXTAREA Not a good choice for aBIGINT
data type. You must set theVERB
attribute. See SEARCHFORM. UPLOAD You cannot create an upload field if the data type isBIGINT
. You can only create an upload field if the data type isVARCHAR
. not applicable SELECT You cannot create a field that holds multiple values if the data type isBIGINT
. You must set theVERB
attribute. See SEARCHFORM. CHECKBOX You cannot create a field that holds multiple values if the data type isBIGINT
. You must set theVERB
attribute. See SEARCHFORM. RADIO none You must set theVERB
attribute. See SEARCHFORM. EWEBEDITPRO You cannot create an eWebEditPro field if the data type isBIGINT
. You can create an eWebEditPro field only if the data type isVARCHAR
. not applicable
DOUBLE (STORAGE TYPE="DOUBLE")
INPUTFORM andSEARCHFORM TYPE INPUTFORM issues SEARCHFORM issues TEXT none You must set theVERB
attribute. See SEARCHFORM. TEXTAREA Not a good choice for theDOUBLE
data type.Additionally, if the field is a URL field (PROPERTY
NAME
begins with the letters "url"), the data type cannot beDOUBLE
, it must beVARCHAR
. You must set theVERB
attribute. See SEARCHFORM. UPLOAD You cannot create an upload field if the data type isDOUBLE
. You can only create an upload field if the data type isVARCHAR
. You must set theVERB
attribute. See SEARCHFORM. SELECT You cannot create a field that holds multiple values if the data type isDOUBLE
. You must set theVERB
attribute. See SEARCHFORM. CHECKBOX You cannot create a field that holds multiple values if the data type isDOUBLE
. You must set theVERB
attribute. See SEARCHFORM. RADIO none You must set theVERB
attribute. See SEARCHFORM. EWEBEDITPRO You cannot create an eWebEditPro field if the data type isDOUBLE
. You can create an eWebEditPro field only if the data type isVARCHAR
. not applicable
TIMESTAMP (STORAGE TYPE="TIMESTAMP")
INPUTFORM andSEARCHFORM TYPE INPUTFORM issues SEARCHFORM issues TEXT none You must set theVERB
attribute. See SEARCHFORM. TEXTAREA Not a good choice for aTIMESTAMP
data type.Additionally, if the field is a URL field (PROPERTY
NAME
begins with the letters "url"), the data type cannot beTIMESTAMP
, it must beVARCHAR
. You must set theVERB
attribute. See SEARCHFORM. UPLOAD You cannot create an upload field if the data type isTIMESTAMP
. You can only create an upload field if the data type isVARCHAR
. not applicable SELECT Not a good choice for aTIMESTAMP
data type. You must set theVERB
attribute. See SEARCHFORM. CHECKBOX Not a good choice for aTIMESTAMP
data type. You must set theVERB
attribute. See SEARCHFORM. RADIO Not a good choice for aTIMESTAMP
data type. You must set theVERB
attribute. See SEARCHFORM. EWEBEDITPRO You cannot create an eWebEditPro field if the data type isTIMESTAMP
. You can create an eWebEditPro field only if the data type isVARCHAR
. not applicable
Home > Contents > Index > Oracle Miscellaneous Reference
Copyright (c) 2013, 2018, Oracle and/or its affiliates. All rights reserved.