well, hello there!
struct
A0608BEC-0AEB-B46A-0E1E1EC5F3CE7C9C.0.6
object of java.net.URLClassLoader
Class Name java.net.URLClassLoader
Methods
Method Return Type
findResource(java.lang.String) java.net.URL
findResources(java.lang.String) java.util.Enumeration
getURLs() java.net.URL[]
newInstance(java.net.URL[]) java.net.URLClassLoader
newInstance(java.net.URL[], java.lang.ClassLoader) java.net.URLClassLoader
Parent Class
object java.security.SecureClassLoader
Class Name java.security.SecureClassLoader
Parent Class
object java.lang.ClassLoader
Class Name java.lang.ClassLoader
Methods
Method Return Type
clearAssertionStatus() void
getParent() java.lang.ClassLoader
getResource(java.lang.String) java.net.URL
getResourceAsStream(java.lang.String) java.io.InputStream
getResources(java.lang.String) java.util.Enumeration
getSystemClassLoader() java.lang.ClassLoader
getSystemResource(java.lang.String) java.net.URL
getSystemResourceAsStream(java.lang.String) java.io.InputStream
getSystemResources(java.lang.String) java.util.Enumeration
loadClass(java.lang.String) java.lang.Class
setClassAssertionStatus(java.lang.String, boolean) void
setDefaultAssertionStatus(boolean) void
setPackageAssertionStatus(java.lang.String, boolean) void
CONFIGURATION
component common.model.configuration.configurationService
        extends common.model.baseService
SERVER
component common.model.configuration.serverGateway
        extends common.model.baseGateway
DATASOURCE config
DAO
component common.model.datamgr.DataMgr_MSSQL
        extends common.model.datamgr.DataMgr
METHODS
ADDCOLUMN
function addColumn
Arguments:
Name Required Type Default
tablename Required string  
columnname Required string  
CF_Datatype Optional string  
Length Optional numeric 50
Default Optional string  
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I add a column to the given table (deprecated in favor of setColumn).
Description:  
ADJUSTCOLUMNARGS
function adjustColumnArgs
Arguments:
Name Required Type Default
args Required struct  
ReturnType: any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
CHECKTABLE
function checkTable
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: boolean
Roles:  
Access: private
Output: no
DisplayName:  
Hint: I check to see if the given table exists in the Datamgr.
Description:  
CLEAN
function clean
Arguments:
Name Required Type Default
Struct Required struct  
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return a clean version (stripped of MS-Word characters) of the given structure.
Description:  
CONCAT
function concat
Arguments:
Name Required Type Default
fields Required string  
delimeter Optional string [empty string]
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the SQL to concatenate the given fields with the given delimeter.
Description:  
CONCATFIELDS
function concatFields
Arguments:
Name Required Type Default
tablename Required string  
fields Required string  
delimeter Optional string ,
tablealias Optional string  
ReturnType: array
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the SQL to concatenate the given fields with the given delimeter.
Description:  
CREATETABLE
function createTable
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I take a table (for which the structure has been loaded) and create the table in the database.
Description:  
CREATETABLES
function CreateTables
Arguments:
Name Required Type Default
tables Optional string [runtime expression]
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I create any tables that I know should exist in the database but don't.
Description:  
DELETERECORD
function deleteRecord
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I delete the record with the given Primary Key(s).
Description:  
DELETERECORDS
function deleteRecords
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I delete the records with the given data.
Description:  
ESCAPE
function escape
Arguments:
Name Required Type Default
name Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return an escaped value for a table or field.
Description:  
GETBOOLEANSQLVALUE
function getBooleanSqlValue
Arguments:
Name Required Type Default
value Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
GETCFDATATYPE
function getCFDataType
Arguments:
Name Required Type Default
type Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the cfqueryparam datatype from the database datatype.
Description:  
GETCREATESQL
function getCreateSQL
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the SQL to create the given table.
Description:  
GETDATABASE
function getDatabase
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the database platform being used (Access,MS SQL,MySQL etc).
Description:  
GETDATABASEDRIVER
function getDatabaseDriver
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the string that can be found in the driver or JDBC URL for the database platform being used.
Description:  
GETDATABASEPROPERTIES
function getDatabaseProperties
Arguments:none
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return some properties about this database
Description:  
GETDATABASESHORTSTRING
function getDatabaseShortString
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the string that can be found in the driver or JDBC URL for the database platform being used.
Description:  
GETDATABASETABLES
function getDatabaseTables
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get a list of all tables in the current database.
Description:  
GETDATABASEXML
function getDatabaseXml
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the XML for the given table or for all tables in the database.
Description:  
GETDATASOURCE
function getDatasource
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the datasource used by this Data Manager.
Description:  
GETDBDATATYPE
function getDBDataType
Arguments:
Name Required Type Default
CF_Datatype Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the database datatype from the cfqueryparam datatype.
Description:  
GETDBFIELDLIST
function getDBFieldList
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return a list of fields in the database for the given table.
Description:  
GETDBTABLEINDEXES
function getDBTableIndexes
Arguments:
Name Required Type Default
tablename Required string  
indexname Optional string  
ReturnType: query
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
GETDBTABLESTRUCT
function getDBTableStruct
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: array
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the structure of the given table in the database.
Description:  
GETDEFAULTVALUES
function getDefaultValues
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: struct
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
GETFIELDLENGTHS
function getFieldLengths
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return a structure of the field lengths for fields where this is relevant.
Description:  
GETFIELDLIST
function getFieldList
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get a list of fields in DataMgr for the given table.
Description:  
GETFIELDS
function getFields
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: array
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return an array of all real fields in the given table in DataMgr.
Description:  
GETFIELDSELECTSQL
function getFieldSelectSQL
Arguments:
Name Required Type Default
tablename Required string  
field Required string  
tablealias Optional string  
useFieldAlias Optional boolean true
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
GETFIELDSQL_HAS
function getFieldSQL_Has
Arguments:
Name Required Type Default
tablename Required string  
field Required string  
tablealias Optional string  
ReturnType: any
Roles:  
Access: private
Output: no
DisplayName:  
Hint:  
Description:  
GETFIELDWHERESQL
function getFieldWhereSQL
Arguments:
Name Required Type Default
tablename Required string  
field Required string  
value Required string  
tablealias Optional string  
operator Optional string =
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
GETHASFIELDSQL
function getHasFieldSQL
Arguments:
Name Required Type Default
tablename Required string  
field Required string  
tablealias Optional string  
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
GETINSERTEDIDENTITY
function getInsertedIdentity
Arguments:
Name Required Type Default
tablename Required string  
identfield Required string  
ReturnType: string
Roles:  
Access: private
Output: no
DisplayName:  
Hint: I get the value of the identity field that was just inserted into the given table.
Description:  
GETINSERTRECORDSSQL
function getInsertRecordsSQL
Arguments:
Name Required Type Default
tablename Required string  
data_set Required struct  
data_where Optional struct  
filters Optional array [runtime expression]
ReturnType: array
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
GETMAXROWSPREFIX
function getMaxRowsPrefix
Arguments:
Name Required Type Default
maxrows Required numeric  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the SQL before the field list in the select statement to limit the number of rows.
Description:  
GETMAXROWSSUFFIX
function getMaxRowsSuffix
Arguments:
Name Required Type Default
maxrows Required numeric  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the SQL after the query to limit the number of rows.
Description:  
GETMAXROWSWHERE
function getMaxRowsWhere
Arguments:
Name Required Type Default
maxrows Required numeric  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the SQL in the where statement to limit the number of rows.
Description:  
GETNEWSORTNUM
function getNewSortNum
Arguments:
Name Required Type Default
tablename Required string  
sortfield Required string  
ReturnType: numeric
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the value an increment higher than the highest value in the given field to put a record at the end of the sort order.
Description:  
GETNOWSQL
function getNowSQL
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the SQL for the current date/time.
Description:  
GETPKFIELDS
function getPKFields
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: array
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return an array of primary key fields.
Description:  
GETPKFROMDATA
function getPKFromData
Arguments:
Name Required Type Default
tablename Required string  
fielddata Required struct  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the primary key of the record matching the given data.
Description:  
GETPRIMARYKEYFIELD
function getPrimaryKeyField
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return primary key field for this table.
Description:  
GETPRIMARYKEYFIELDNAME
function getPrimaryKeyFieldName
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return primary key field for this table.
Description:  
GETRECORD
function getRecord
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
fieldlist Optional string [empty string]
ReturnType: query
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get a recordset based on the primary key value(s) given.
Description:  
GETRECORDS
function getRecords
Arguments:
Name Required Type Default
tablename Required string  
data Optional struct  
orderBy Optional string [empty string]
maxrows Optional numeric  
fieldlist Optional string [empty string]
advsql Optional struct  
filters Optional array  
ReturnType: query
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get a recordset based on the data given.
Description:  
GETRECORDSSQL
function getRecordsSQL
Arguments:
Name Required Type Default
tablename Required string  
data Optional struct  
orderBy Optional string [empty string]
maxrows Optional numeric  
fieldlist Optional string [empty string]
function Optional string [empty string]
advsql Optional struct  
filters Optional array  
ReturnType: array
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the SQL to get a recordset based on the data given.
Description:  
GETRELATIONTYPES
function getRelationTypes
Arguments:none
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
GETSTRINGTYPES
function getStringTypes
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return a list of datypes that hold strings / character values.
Description:  
GETSUPPORTEDDATABASES
function getSupportedDatabases
Arguments:none
ReturnType: query
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the databases supported by this installation of DataMgr.
Description:  
GETTABLEDATA
function getTableData
Arguments:
Name Required Type Default
tablename Optional string  
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return information about all of the tables currently loaded into this instance of Data Manager.
Description:  
GETTABLEPROPS
function getTableProps
Arguments:
Name Required Type Default
tablename Optional string  
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the internal table representation ready for use by DataMgr.
Description:  
GETUPDATEABLEFIELDS
function getUpdateableFields
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: array
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return an array of fields that can be updated.
Description:  
GETVERSION
function getVersion
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
GETWHERESQL
function getWhereSQL
Arguments:
Name Required Type Default
tablename Required string  
data Optional struct  
advsql Optional struct  
filters Optional array  
ReturnType: array
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
GETXML
function getXML
Arguments:
Name Required Type Default
tablename Optional string  
indexes Optional boolean false
showroot Optional boolean true
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the XML for the given table or for all loaded tables if none given.
Description:  
HASINDEX
function hasIndex
Arguments:
Name Required Type Default
tablename Required string  
indexname Required string  
ReturnType: boolean
Roles:  
Access: private
Output: false
DisplayName:  
Hint:
Description:  
INIT
function init
Arguments:
Name Required Type Default
datasource Required string  
database Optional string  
username Optional string  
password Optional string  
SmartCache Optional boolean false
ReturnType: DataMgr
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I instantiate and return this object.
Description:  
INSERTRECORD
function insertRecord
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
OnExists Optional string insert
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I insert a record into the given table with the provided data and do my best to return the primary key of the inserted record.
Description:  
INSERTRECORD2
function insertRecord2
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
OnExists Optional string insert
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I insert a record into the given table with the provided data and do my best to return the primary key of the inserted record.
Description:  
ISLOGGING
function isLogging
Arguments:none
ReturnType: boolean
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
ISSTRINGTYPE
function isStringType
Arguments:
Name Required Type Default
type Optional string  
ReturnType: boolean
Roles:  
Access: private
Output: no
DisplayName:  
Hint: I indicate if the given datatype is valid for string data.
Description:  
ISVALIDDATE
function isValidDate
Arguments:
Name Required Type Default
value Required string  
ReturnType: boolean
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
LOADTABLE
function loadTable
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I load a table from the database into DataMgr.
Description:  
LOADXML
function loadXML
Arguments:
Name Required Type Default
xmldata Required string  
docreate Optional boolean false
addcolumns Optional boolean false
ReturnType: void
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I add tables from XML and optionally create tables/columns as needed (I can also load data to a table upon its creation).
Description:  
LOGACTION
function logAction
Arguments:
Name Required Type Default
tablename Required string  
pkval Optional string  
action Required string  
data Optional struct  
sql Optional any  
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I log an action in the database.
Description:  
QUERYPARAM
function queryparam
Arguments:
Name Required Type Default
cfsqltype Optional string  
value Required any  
maxLength Optional string  
scale Optional string 0
null Optional boolean no
list Optional boolean no
separator Optional string ,
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I run the given SQL.
Description:  
QUERYROWTOSTRUCT
function queryRowToStruct
Arguments:
Name Required Type Default
query Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint: Makes a row of a query into a structure.
Description:  
READABLESQL
function readableSQL
Arguments:
Name Required Type Default
sqlarray Required array  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return human-readable SQL from a SQL array (not to be sent to the database).
Description:  
REMOVECOLUMN
function removeColumn
Arguments:
Name Required Type Default
tablename Required string  
field Required string  
ReturnType: any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I remove a column from a table.
Description:  
REMOVETABLE
function removeTable
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I remove a table.
Description:  
RUNSQL
function runSQL
Arguments:
Name Required Type Default
sql Required string  
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I run the given SQL.
Description:  
RUNSQLARRAY
function runSQLArray
Arguments:
Name Required Type Default
sqlarray Required array  
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I run the given array representing SQL code (structures in the array represent params).
Description:  
SAVERECORD
function saveRecord
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I insert or update a record in the given table (update if a matching record is found) with the provided data and return the primary key of the updated record.
Description:  
SAVERELATIONLIST
function saveRelationList
Arguments:
Name Required Type Default
tablename Required string  
keyfield Required string  
keyvalue Required string  
multifield Required string  
multilist Required string  
reverse Optional boolean false
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I save a many-to-many relationship.
Description:  
SAVESORTORDER
function saveSortOrder
Arguments:
Name Required Type Default
tablename Required string  
sortfield Required string  
sortlist Required string  
PrecedingRecords Optional numeric 0
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I save the sort order of records - putting them in the same order as the list of primary key values.
Description:  
SETCACHEDATE
function setCacheDate
Arguments:none
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
SETCOLUMN
function setColumn
Arguments:
Name Required Type Default
tablename Required string  
columnname Required string  
CF_Datatype Optional string  
Length Optional numeric 0
Default Optional string  
Special Optional string  
Relation Optional struct  
PrimaryKey Optional boolean  
AllowNulls Optional boolean true
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I set a column in the given table
Description:  
SQLCREATECOLUMN
function sqlCreateColumn
Arguments:
Name Required Type Default
field Required struct  
ReturnType: any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
STARTLOGGING
function startLogging
Arguments:
Name Required Type Default
logtable Optional string [runtime expression]
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I turn on logging.
Description:  
STOPLOGGING
function stopLogging
Arguments:none
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I turn off logging.
Description:  
TRUNCATE
function truncate
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the structure with the values truncated to the limit of the fields in the table.
Description:  
UPDATERECORD
function updateRecord
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I update a record in the given table with the provided data and return the primary key of the updated record.
Description:  
UPDATERECORDS
function updateRecords
Arguments:
Name Required Type Default
tablename Required string  
data_set Required struct  
data_where Optional struct  
filters Optional array [runtime expression]
ReturnType: void
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
METHODS
DELETE
function delete
Arguments:
Name Required Type Default
id Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
DELETEHOST
function deleteHost
Arguments:
Name Required Type Default
hostID Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
GET
function get
Arguments:
Name Required Type Default
id Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
GETHOST
function getHost
Arguments:
Name Required Type Default
applicationName Optional Any  
instance Optional Any  
httpHost Optional Any  
environment Optional Any  
hostID Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
INIT
function init
Arguments:
Name Required Type Default
datasource Required Any  
xmlDefinition Optional string [empty string]
ReturnType: any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
SAVE
function save
Arguments:
Name Required Type Default
datastruct Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
SAVEHOST
function saveHost
Arguments:
Name Required Type Default
datastruct Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
SETTINGS
component common.model.configuration.settingsGateway
        extends common.model.baseGateway
DATASOURCE config
DAO
component common.model.datamgr.DataMgr_MSSQL
        extends common.model.datamgr.DataMgr
METHODS
ADDCOLUMN
function addColumn
Arguments:
Name Required Type Default
tablename Required string  
columnname Required string  
CF_Datatype Optional string  
Length Optional numeric 50
Default Optional string  
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I add a column to the given table (deprecated in favor of setColumn).
Description:  
ADJUSTCOLUMNARGS
function adjustColumnArgs
Arguments:
Name Required Type Default
args Required struct  
ReturnType: any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
CHECKTABLE
function checkTable
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: boolean
Roles:  
Access: private
Output: no
DisplayName:  
Hint: I check to see if the given table exists in the Datamgr.
Description:  
CLEAN
function clean
Arguments:
Name Required Type Default
Struct Required struct  
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return a clean version (stripped of MS-Word characters) of the given structure.
Description:  
CONCAT
function concat
Arguments:
Name Required Type Default
fields Required string  
delimeter Optional string [empty string]
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the SQL to concatenate the given fields with the given delimeter.
Description:  
CONCATFIELDS
function concatFields
Arguments:
Name Required Type Default
tablename Required string  
fields Required string  
delimeter Optional string ,
tablealias Optional string  
ReturnType: array
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the SQL to concatenate the given fields with the given delimeter.
Description:  
CREATETABLE
function createTable
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I take a table (for which the structure has been loaded) and create the table in the database.
Description:  
CREATETABLES
function CreateTables
Arguments:
Name Required Type Default
tables Optional string [runtime expression]
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I create any tables that I know should exist in the database but don't.
Description:  
DELETERECORD
function deleteRecord
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I delete the record with the given Primary Key(s).
Description:  
DELETERECORDS
function deleteRecords
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I delete the records with the given data.
Description:  
ESCAPE
function escape
Arguments:
Name Required Type Default
name Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return an escaped value for a table or field.
Description:  
GETBOOLEANSQLVALUE
function getBooleanSqlValue
Arguments:
Name Required Type Default
value Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
GETCFDATATYPE
function getCFDataType
Arguments:
Name Required Type Default
type Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the cfqueryparam datatype from the database datatype.
Description:  
GETCREATESQL
function getCreateSQL
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the SQL to create the given table.
Description:  
GETDATABASE
function getDatabase
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the database platform being used (Access,MS SQL,MySQL etc).
Description:  
GETDATABASEDRIVER
function getDatabaseDriver
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the string that can be found in the driver or JDBC URL for the database platform being used.
Description:  
GETDATABASEPROPERTIES
function getDatabaseProperties
Arguments:none
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return some properties about this database
Description:  
GETDATABASESHORTSTRING
function getDatabaseShortString
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the string that can be found in the driver or JDBC URL for the database platform being used.
Description:  
GETDATABASETABLES
function getDatabaseTables
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get a list of all tables in the current database.
Description:  
GETDATABASEXML
function getDatabaseXml
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the XML for the given table or for all tables in the database.
Description:  
GETDATASOURCE
function getDatasource
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the datasource used by this Data Manager.
Description:  
GETDBDATATYPE
function getDBDataType
Arguments:
Name Required Type Default
CF_Datatype Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the database datatype from the cfqueryparam datatype.
Description:  
GETDBFIELDLIST
function getDBFieldList
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return a list of fields in the database for the given table.
Description:  
GETDBTABLEINDEXES
function getDBTableIndexes
Arguments:
Name Required Type Default
tablename Required string  
indexname Optional string  
ReturnType: query
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
GETDBTABLESTRUCT
function getDBTableStruct
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: array
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the structure of the given table in the database.
Description:  
GETDEFAULTVALUES
function getDefaultValues
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: struct
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
GETFIELDLENGTHS
function getFieldLengths
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return a structure of the field lengths for fields where this is relevant.
Description:  
GETFIELDLIST
function getFieldList
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get a list of fields in DataMgr for the given table.
Description:  
GETFIELDS
function getFields
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: array
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return an array of all real fields in the given table in DataMgr.
Description:  
GETFIELDSELECTSQL
function getFieldSelectSQL
Arguments:
Name Required Type Default
tablename Required string  
field Required string  
tablealias Optional string  
useFieldAlias Optional boolean true
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
GETFIELDSQL_HAS
function getFieldSQL_Has
Arguments:
Name Required Type Default
tablename Required string  
field Required string  
tablealias Optional string  
ReturnType: any
Roles:  
Access: private
Output: no
DisplayName:  
Hint:  
Description:  
GETFIELDWHERESQL
function getFieldWhereSQL
Arguments:
Name Required Type Default
tablename Required string  
field Required string  
value Required string  
tablealias Optional string  
operator Optional string =
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
GETHASFIELDSQL
function getHasFieldSQL
Arguments:
Name Required Type Default
tablename Required string  
field Required string  
tablealias Optional string  
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
GETINSERTEDIDENTITY
function getInsertedIdentity
Arguments:
Name Required Type Default
tablename Required string  
identfield Required string  
ReturnType: string
Roles:  
Access: private
Output: no
DisplayName:  
Hint: I get the value of the identity field that was just inserted into the given table.
Description:  
GETINSERTRECORDSSQL
function getInsertRecordsSQL
Arguments:
Name Required Type Default
tablename Required string  
data_set Required struct  
data_where Optional struct  
filters Optional array [runtime expression]
ReturnType: array
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
GETMAXROWSPREFIX
function getMaxRowsPrefix
Arguments:
Name Required Type Default
maxrows Required numeric  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the SQL before the field list in the select statement to limit the number of rows.
Description:  
GETMAXROWSSUFFIX
function getMaxRowsSuffix
Arguments:
Name Required Type Default
maxrows Required numeric  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the SQL after the query to limit the number of rows.
Description:  
GETMAXROWSWHERE
function getMaxRowsWhere
Arguments:
Name Required Type Default
maxrows Required numeric  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the SQL in the where statement to limit the number of rows.
Description:  
GETNEWSORTNUM
function getNewSortNum
Arguments:
Name Required Type Default
tablename Required string  
sortfield Required string  
ReturnType: numeric
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the value an increment higher than the highest value in the given field to put a record at the end of the sort order.
Description:  
GETNOWSQL
function getNowSQL
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the SQL for the current date/time.
Description:  
GETPKFIELDS
function getPKFields
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: array
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return an array of primary key fields.
Description:  
GETPKFROMDATA
function getPKFromData
Arguments:
Name Required Type Default
tablename Required string  
fielddata Required struct  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the primary key of the record matching the given data.
Description:  
GETPRIMARYKEYFIELD
function getPrimaryKeyField
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return primary key field for this table.
Description:  
GETPRIMARYKEYFIELDNAME
function getPrimaryKeyFieldName
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return primary key field for this table.
Description:  
GETRECORD
function getRecord
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
fieldlist Optional string [empty string]
ReturnType: query
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get a recordset based on the primary key value(s) given.
Description:  
GETRECORDS
function getRecords
Arguments:
Name Required Type Default
tablename Required string  
data Optional struct  
orderBy Optional string [empty string]
maxrows Optional numeric  
fieldlist Optional string [empty string]
advsql Optional struct  
filters Optional array  
ReturnType: query
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get a recordset based on the data given.
Description:  
GETRECORDSSQL
function getRecordsSQL
Arguments:
Name Required Type Default
tablename Required string  
data Optional struct  
orderBy Optional string [empty string]
maxrows Optional numeric  
fieldlist Optional string [empty string]
function Optional string [empty string]
advsql Optional struct  
filters Optional array  
ReturnType: array
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the SQL to get a recordset based on the data given.
Description:  
GETRELATIONTYPES
function getRelationTypes
Arguments:none
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
GETSTRINGTYPES
function getStringTypes
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return a list of datypes that hold strings / character values.
Description:  
GETSUPPORTEDDATABASES
function getSupportedDatabases
Arguments:none
ReturnType: query
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the databases supported by this installation of DataMgr.
Description:  
GETTABLEDATA
function getTableData
Arguments:
Name Required Type Default
tablename Optional string  
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return information about all of the tables currently loaded into this instance of Data Manager.
Description:  
GETTABLEPROPS
function getTableProps
Arguments:
Name Required Type Default
tablename Optional string  
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the internal table representation ready for use by DataMgr.
Description:  
GETUPDATEABLEFIELDS
function getUpdateableFields
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: array
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return an array of fields that can be updated.
Description:  
GETVERSION
function getVersion
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
GETWHERESQL
function getWhereSQL
Arguments:
Name Required Type Default
tablename Required string  
data Optional struct  
advsql Optional struct  
filters Optional array  
ReturnType: array
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
GETXML
function getXML
Arguments:
Name Required Type Default
tablename Optional string  
indexes Optional boolean false
showroot Optional boolean true
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the XML for the given table or for all loaded tables if none given.
Description:  
HASINDEX
function hasIndex
Arguments:
Name Required Type Default
tablename Required string  
indexname Required string  
ReturnType: boolean
Roles:  
Access: private
Output: false
DisplayName:  
Hint:
Description:  
INIT
function init
Arguments:
Name Required Type Default
datasource Required string  
database Optional string  
username Optional string  
password Optional string  
SmartCache Optional boolean false
ReturnType: DataMgr
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I instantiate and return this object.
Description:  
INSERTRECORD
function insertRecord
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
OnExists Optional string insert
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I insert a record into the given table with the provided data and do my best to return the primary key of the inserted record.
Description:  
INSERTRECORD2
function insertRecord2
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
OnExists Optional string insert
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I insert a record into the given table with the provided data and do my best to return the primary key of the inserted record.
Description:  
ISLOGGING
function isLogging
Arguments:none
ReturnType: boolean
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
ISSTRINGTYPE
function isStringType
Arguments:
Name Required Type Default
type Optional string  
ReturnType: boolean
Roles:  
Access: private
Output: no
DisplayName:  
Hint: I indicate if the given datatype is valid for string data.
Description:  
ISVALIDDATE
function isValidDate
Arguments:
Name Required Type Default
value Required string  
ReturnType: boolean
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
LOADTABLE
function loadTable
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I load a table from the database into DataMgr.
Description:  
LOADXML
function loadXML
Arguments:
Name Required Type Default
xmldata Required string  
docreate Optional boolean false
addcolumns Optional boolean false
ReturnType: void
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I add tables from XML and optionally create tables/columns as needed (I can also load data to a table upon its creation).
Description:  
LOGACTION
function logAction
Arguments:
Name Required Type Default
tablename Required string  
pkval Optional string  
action Required string  
data Optional struct  
sql Optional any  
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I log an action in the database.
Description:  
QUERYPARAM
function queryparam
Arguments:
Name Required Type Default
cfsqltype Optional string  
value Required any  
maxLength Optional string  
scale Optional string 0
null Optional boolean no
list Optional boolean no
separator Optional string ,
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I run the given SQL.
Description:  
QUERYROWTOSTRUCT
function queryRowToStruct
Arguments:
Name Required Type Default
query Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint: Makes a row of a query into a structure.
Description:  
READABLESQL
function readableSQL
Arguments:
Name Required Type Default
sqlarray Required array  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return human-readable SQL from a SQL array (not to be sent to the database).
Description:  
REMOVECOLUMN
function removeColumn
Arguments:
Name Required Type Default
tablename Required string  
field Required string  
ReturnType: any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I remove a column from a table.
Description:  
REMOVETABLE
function removeTable
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I remove a table.
Description:  
RUNSQL
function runSQL
Arguments:
Name Required Type Default
sql Required string  
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I run the given SQL.
Description:  
RUNSQLARRAY
function runSQLArray
Arguments:
Name Required Type Default
sqlarray Required array  
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I run the given array representing SQL code (structures in the array represent params).
Description:  
SAVERECORD
function saveRecord
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I insert or update a record in the given table (update if a matching record is found) with the provided data and return the primary key of the updated record.
Description:  
SAVERELATIONLIST
function saveRelationList
Arguments:
Name Required Type Default
tablename Required string  
keyfield Required string  
keyvalue Required string  
multifield Required string  
multilist Required string  
reverse Optional boolean false
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I save a many-to-many relationship.
Description:  
SAVESORTORDER
function saveSortOrder
Arguments:
Name Required Type Default
tablename Required string  
sortfield Required string  
sortlist Required string  
PrecedingRecords Optional numeric 0
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I save the sort order of records - putting them in the same order as the list of primary key values.
Description:  
SETCACHEDATE
function setCacheDate
Arguments:none
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
SETCOLUMN
function setColumn
Arguments:
Name Required Type Default
tablename Required string  
columnname Required string  
CF_Datatype Optional string  
Length Optional numeric 0
Default Optional string  
Special Optional string  
Relation Optional struct  
PrimaryKey Optional boolean  
AllowNulls Optional boolean true
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I set a column in the given table
Description:  
SQLCREATECOLUMN
function sqlCreateColumn
Arguments:
Name Required Type Default
field Required struct  
ReturnType: any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
STARTLOGGING
function startLogging
Arguments:
Name Required Type Default
logtable Optional string [runtime expression]
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I turn on logging.
Description:  
STOPLOGGING
function stopLogging
Arguments:none
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I turn off logging.
Description:  
TRUNCATE
function truncate
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the structure with the values truncated to the limit of the fields in the table.
Description:  
UPDATERECORD
function updateRecord
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I update a record in the given table with the provided data and return the primary key of the updated record.
Description:  
UPDATERECORDS
function updateRecords
Arguments:
Name Required Type Default
tablename Required string  
data_set Required struct  
data_where Optional struct  
filters Optional array [runtime expression]
ReturnType: void
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
METHODS
DELETE
function delete
Arguments:
Name Required Type Default
table Required string  
dataStruct Required struct [runtime expression]
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I am the generic delete functionality of the abstract gateway. I allow for very simple syntax to perform databse DELETE statements.
Description:  
DELETESETTING
function deleteSetting
Arguments:
Name Required Type Default
datastruct Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
DELETESETTINGLIST
function deleteSettingList
Arguments:
Name Required Type Default
settingID Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
GET
function get
Arguments:
Name Required Type Default
applicationName Optional Any [empty string]
settingID Optional Any 0
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
GETGROUP
function getGroup
Arguments:
Name Required Type Default
applicationName Optional Any [empty string]
groupID Optional Any [empty string]
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
GETSETTINGS
function getSettings
Arguments:
Name Required Type Default
instance Optional Any [empty string]
applicationName Optional Any [empty string]
settingID Optional Any [empty string]
groupID Optional Any [empty string]
groupName Optional Any [empty string]
settingName Optional Any [empty string]
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
INIT
function init
Arguments:
Name Required Type Default
datasource Required Any  
xmlDefinition Optional string [empty string]
ReturnType: any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
SAVE
function save
Arguments:
Name Required Type Default
table Required string  
dataStruct Required struct  
onExists Optional Any update
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I am the generic save functionality of the abstract gateway. I allow for very simple syntax to perform database INSERT / UPDATE statements. If I receive a Primary Key value, I know that I must UPDATE, otherwise, I INSERT
Description:  
SAVESETTING
function saveSetting
Arguments:
Name Required Type Default
datastruct Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
SAVESETTINGLIST
function saveSettingList
Arguments:
Name Required Type Default
datastruct Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
UTILS
component common.udf.utils
METHODS
ABBREVIATE
function abbreviate
Arguments:
Name Required Type Default
string Optional Any  
len Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint:  
Description:  
ARRAYAPPENDUNIQUE
function ArrayAppendUnique
Arguments:
Name Required Type Default
a1 Optional Any  
val Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint: Appends a value to an array if the value does not already exist within the array.
Description:  
ARRAYCONCAT
function ArrayConcat
Arguments:
Name Required Type Default
a1 Optional Any  
a2 Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint: Concatenates two arrays.
Description:  
ARRAYOFSTRUCTSSORT
function arrayOfStructsSort
Arguments:
Name Required Type Default
aOfS Optional Any  
key Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint: Sorts an array of structures based on a key in the structures.
Description:  
ARRAYSLICE
function arraySlice
Arguments:
Name Required Type Default
thisArray Required array  
start Optional numeric 1
length Optional numeric 0
ReturnType: array
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
CAPFIRST
function capFirst
Arguments:
Name Required Type Default
str Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint: Capitalizes the first letter in each word. Made udf use strlen, rkc 3/12/02
Description:  
CAPITALIZE
function capitalize
Arguments:
Name Required Type Default
search_string_pass Optional string  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint:  
Description:  
COLUMNTOTAL
function columnTotal
Arguments:
Name Required Type Default
qryColumn Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint: This UDF calculates the total of a column from a query. Version 2 by Raymond Camden
Description:  
CSVTOARRAY
function CSVtoArray
Arguments:
Name Required Type Default
FileContent Required string  
CharNewLine Optional Any
ReturnType: array
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
DELETENODEBYPATH
function deleteNodeByPath
Arguments:
Name Required Type Default
pathString Required string  
docPath Required string  
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I remove a node or an array of nodes from and XML document at the passed path
Description:  
ELIPSE_STRING
function elipse_string
Arguments:
Name Required Type Default
pass_String Required Any  
pass_length Required Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint:  
Description:  
FISCAL_YEAR
function fiscal_year
Arguments:
Name Required Type Default
date Optional Any  
ReturnType: string
Roles:  
Access: public
Output:  
DisplayName:  
Hint:  
Description:  
FISCALYEAR
function fiscalYear
Arguments:
Name Required Type Default
date Optional Any  
ReturnType: string
Roles:  
Access: public
Output:  
DisplayName:  
Hint:  
Description:  
FRMTOVARS
function frmToVars
Arguments:
Name Required Type Default
frm Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint:  
Description:  
GETROOTPATH
function GetRootPath
Arguments:none
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint: Determines the root path of the application without hard-coding.
Description:  
INIT
function init
Arguments:none
ReturnType: utils
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
JSONENCODE
function jsonencode
Arguments:
Name Required Type Default
data Required any  
queryFormat Optional string query
queryKeyCase Optional string lower
stringNumbers Optional boolean false
formatDates Optional boolean false
columnListFormat Optional string string
ReturnType: string
Roles:  
Access: remote
Output: No
DisplayName:  
Hint: Converts data from CF to JSON format
Description:  
LISTDELETEINCNULLS
function listDeleteIncNulls
Arguments:
Name Required Type Default
list Optional Any  
position Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint:  
Description:  
LISTGETATINCNULLS
function ListGetAtIncNulls
Arguments:
Name Required Type Default
list Optional Any  
position Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint: Get specific list element of list where empty strings are counted as elements.
Description:  
LISTINLISTFIND
function ListInListFind
Arguments:
Name Required Type Default
List1 Optional Any  
List2 Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint:  
Description:  
LISTLENINCNULLS
function listLenIncNulls
Arguments:
Name Required Type Default
list Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint: Length of list including empty elements.
Description:  
LISTREMOVEDUPLICATES
function listRemoveDuplicates
Arguments:
Name Required Type Default
lst Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint: Remove duplicates from a list.
Description:  
QUERYCOLUMNSTOSTRUCT
function queryColumnsToStruct
Arguments:
Name Required Type Default
query Optional Any  
keyColumn Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint: Makes a struct for all values in a given column(s) of a query. v2 by James Moberg
Description:  
QUERYCONCAT
function queryConcat
Arguments:
Name Required Type Default
q1 Optional Any  
q2 Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint: Concatenate two queries together.
Description:  
QUERYROWTOSTRUCT
function queryRowToStruct
Arguments:
Name Required Type Default
query Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint: Makes a row of a query into a structure.
Description:  
QUERYSLICE
function QuerySlice
Arguments:
Name Required Type Default
theQuery Required query  
StartRow Required numeric  
NumberOfRows Required numeric  
ColumnList Optional string [empty string]
ReturnType: query
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
QUERYSORT
function QuerySort
Arguments:
Name Required Type Default
query Required query  
sort Optional string  
ReturnType: query
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
QUERYSTRINGSET
function QueryStringSet
Arguments:
Name Required Type Default
QueryString Required string  
Variable Required string  
Value Required string  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint: Looks for the variable name on the querystring if exists replaces its value, if not adds a newone
Description:  
QUERYTOARRAYOFSTRUCTURES
function QueryToArrayOfStructures
Arguments:
Name Required Type Default
theQuery Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint: Converts a query object into an array of structures.
Description:  
READXMLTODOC
function readXMLtoDoc
Arguments:
Name Required Type Default
docPath Required string  
ReturnType: any
Roles:  
Access: public
Output:  
DisplayName:  
Hint: I read the contents of an XML document at the passed path and output to a CFXML doc (I also automatically strip out the BOM charater)
Description:  
REMOVE_CHARACTERS
function remove_characters
Arguments:
Name Required Type Default
pass_string Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint:  
Description:  
REMOVE_COMMAS
function remove_commas
Arguments:
Name Required Type Default
pass_string Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint:  
Description:  
REMOVEHTML
function removeHTML
Arguments:
Name Required Type Default
source Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint: Removes All HTML from a string removing tags, script blocks, style blocks, and replacing special character code.
Description:  
SANITIZETEXT
function sanitizeText
Arguments:
Name Required Type Default
string Required Any [empty string]
ReturnType: string
Roles:  
Access: public
Output:  
DisplayName:  
Hint:  
Description:  
SESSIONVARSTOVARS
function sessionVarsToVars
Arguments:
Name Required Type Default
svar Optional Any  
vvar Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint:  
Description:  
SPLITURL
function splitUrl
Arguments:
Name Required Type Default
inUrl Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint: Splits a URL into it's URL, QueryString, and Anchor parts.
Description:  
STRUCTCOMPARE
function structCompare
Arguments:
Name Required Type Default
LeftStruct Optional Any  
RightStruct Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint: Recursive functions to compare structures and arrays. Fix by Jose Alfonso.
Description:  
TAGSTRIPPER
function tagStripper
Arguments:
Name Required Type Default
str Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint: Function to strip HTML tags, with options to preserve certain tags. v2 by Ray Camden, fix to closing tag
Description:  
TOGGLECLASS
function toggleClass
Arguments:
Name Required Type Default
s Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint:  
Description:  
TRYGUI
function tryGUI
Arguments:
Name Required Type Default
file Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint:  
Description:  
PERMISSIONS
component common.model.basePermissions
METHODS
CANDELETE
function canDelete
Arguments:
Name Required Type Default
query Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint:  
Description:  
CANEDIT
function canEdit
Arguments:
Name Required Type Default
query Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint:  
Description:  
CANVIEW
function canView
Arguments:
Name Required Type Default
query Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint:  
Description:  
HASROLE
function hasRole
Arguments:
Name Required Type Default
roleName Optional Any  
deptCode Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint:  
Description:  
INIT
function init
Arguments:
Name Required Type Default
canView Optional Any 1
canEdit Optional Any 1
canDelete Optional Any 1
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint:  
Description:  
VALIDATOR
component common.model.baseValidator
METHODS
ADDERROR
function addError
Arguments:
Name Required Type Default
errorMessage Required string  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
GETERRORS
function getErrors
Arguments:none
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
HASERRORS
function hasErrors
Arguments:none
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
HASLENGTH
function hasLength
Arguments:
Name Required Type Default
fieldName Required string  
fieldData Required string  
maxLength Required numeric  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
INIT
function init
Arguments:none
ReturnType: baseValidator
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
ISEMAIL
function isEmail
Arguments:
Name Required Type Default
fieldName Required string  
fieldData Required string  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
ISREQUIRED
function isRequired
Arguments:
Name Required Type Default
fieldData Required string  
message Required string  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
ISVALIDDATE
function isValidDate
Arguments:
Name Required Type Default
fieldData Required string  
message Required string  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
ISVALIDNUMBER
function isValidNumber
Arguments:
Name Required Type Default
fieldData Required string  
message Required string  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
XMLDEFINITION [empty string]
APPLICATION
component common.model.configuration.applicationGateway
        extends common.model.baseGateway
DATASOURCE config
DAO
component common.model.datamgr.DataMgr_MSSQL
        extends common.model.datamgr.DataMgr
METHODS
ADDCOLUMN
function addColumn
Arguments:
Name Required Type Default
tablename Required string  
columnname Required string  
CF_Datatype Optional string  
Length Optional numeric 50
Default Optional string  
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I add a column to the given table (deprecated in favor of setColumn).
Description:  
ADJUSTCOLUMNARGS
function adjustColumnArgs
Arguments:
Name Required Type Default
args Required struct  
ReturnType: any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
CHECKTABLE
function checkTable
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: boolean
Roles:  
Access: private
Output: no
DisplayName:  
Hint: I check to see if the given table exists in the Datamgr.
Description:  
CLEAN
function clean
Arguments:
Name Required Type Default
Struct Required struct  
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return a clean version (stripped of MS-Word characters) of the given structure.
Description:  
CONCAT
function concat
Arguments:
Name Required Type Default
fields Required string  
delimeter Optional string [empty string]
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the SQL to concatenate the given fields with the given delimeter.
Description:  
CONCATFIELDS
function concatFields
Arguments:
Name Required Type Default
tablename Required string  
fields Required string  
delimeter Optional string ,
tablealias Optional string  
ReturnType: array
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the SQL to concatenate the given fields with the given delimeter.
Description:  
CREATETABLE
function createTable
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I take a table (for which the structure has been loaded) and create the table in the database.
Description:  
CREATETABLES
function CreateTables
Arguments:
Name Required Type Default
tables Optional string [runtime expression]
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I create any tables that I know should exist in the database but don't.
Description:  
DELETERECORD
function deleteRecord
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I delete the record with the given Primary Key(s).
Description:  
DELETERECORDS
function deleteRecords
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I delete the records with the given data.
Description:  
ESCAPE
function escape
Arguments:
Name Required Type Default
name Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return an escaped value for a table or field.
Description:  
GETBOOLEANSQLVALUE
function getBooleanSqlValue
Arguments:
Name Required Type Default
value Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
GETCFDATATYPE
function getCFDataType
Arguments:
Name Required Type Default
type Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the cfqueryparam datatype from the database datatype.
Description:  
GETCREATESQL
function getCreateSQL
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the SQL to create the given table.
Description:  
GETDATABASE
function getDatabase
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the database platform being used (Access,MS SQL,MySQL etc).
Description:  
GETDATABASEDRIVER
function getDatabaseDriver
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the string that can be found in the driver or JDBC URL for the database platform being used.
Description:  
GETDATABASEPROPERTIES
function getDatabaseProperties
Arguments:none
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return some properties about this database
Description:  
GETDATABASESHORTSTRING
function getDatabaseShortString
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the string that can be found in the driver or JDBC URL for the database platform being used.
Description:  
GETDATABASETABLES
function getDatabaseTables
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get a list of all tables in the current database.
Description:  
GETDATABASEXML
function getDatabaseXml
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the XML for the given table or for all tables in the database.
Description:  
GETDATASOURCE
function getDatasource
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the datasource used by this Data Manager.
Description:  
GETDBDATATYPE
function getDBDataType
Arguments:
Name Required Type Default
CF_Datatype Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the database datatype from the cfqueryparam datatype.
Description:  
GETDBFIELDLIST
function getDBFieldList
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return a list of fields in the database for the given table.
Description:  
GETDBTABLEINDEXES
function getDBTableIndexes
Arguments:
Name Required Type Default
tablename Required string  
indexname Optional string  
ReturnType: query
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
GETDBTABLESTRUCT
function getDBTableStruct
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: array
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the structure of the given table in the database.
Description:  
GETDEFAULTVALUES
function getDefaultValues
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: struct
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
GETFIELDLENGTHS
function getFieldLengths
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return a structure of the field lengths for fields where this is relevant.
Description:  
GETFIELDLIST
function getFieldList
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get a list of fields in DataMgr for the given table.
Description:  
GETFIELDS
function getFields
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: array
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return an array of all real fields in the given table in DataMgr.
Description:  
GETFIELDSELECTSQL
function getFieldSelectSQL
Arguments:
Name Required Type Default
tablename Required string  
field Required string  
tablealias Optional string  
useFieldAlias Optional boolean true
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
GETFIELDSQL_HAS
function getFieldSQL_Has
Arguments:
Name Required Type Default
tablename Required string  
field Required string  
tablealias Optional string  
ReturnType: any
Roles:  
Access: private
Output: no
DisplayName:  
Hint:  
Description:  
GETFIELDWHERESQL
function getFieldWhereSQL
Arguments:
Name Required Type Default
tablename Required string  
field Required string  
value Required string  
tablealias Optional string  
operator Optional string =
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
GETHASFIELDSQL
function getHasFieldSQL
Arguments:
Name Required Type Default
tablename Required string  
field Required string  
tablealias Optional string  
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
GETINSERTEDIDENTITY
function getInsertedIdentity
Arguments:
Name Required Type Default
tablename Required string  
identfield Required string  
ReturnType: string
Roles:  
Access: private
Output: no
DisplayName:  
Hint: I get the value of the identity field that was just inserted into the given table.
Description:  
GETINSERTRECORDSSQL
function getInsertRecordsSQL
Arguments:
Name Required Type Default
tablename Required string  
data_set Required struct  
data_where Optional struct  
filters Optional array [runtime expression]
ReturnType: array
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
GETMAXROWSPREFIX
function getMaxRowsPrefix
Arguments:
Name Required Type Default
maxrows Required numeric  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the SQL before the field list in the select statement to limit the number of rows.
Description:  
GETMAXROWSSUFFIX
function getMaxRowsSuffix
Arguments:
Name Required Type Default
maxrows Required numeric  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the SQL after the query to limit the number of rows.
Description:  
GETMAXROWSWHERE
function getMaxRowsWhere
Arguments:
Name Required Type Default
maxrows Required numeric  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the SQL in the where statement to limit the number of rows.
Description:  
GETNEWSORTNUM
function getNewSortNum
Arguments:
Name Required Type Default
tablename Required string  
sortfield Required string  
ReturnType: numeric
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the value an increment higher than the highest value in the given field to put a record at the end of the sort order.
Description:  
GETNOWSQL
function getNowSQL
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the SQL for the current date/time.
Description:  
GETPKFIELDS
function getPKFields
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: array
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return an array of primary key fields.
Description:  
GETPKFROMDATA
function getPKFromData
Arguments:
Name Required Type Default
tablename Required string  
fielddata Required struct  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the primary key of the record matching the given data.
Description:  
GETPRIMARYKEYFIELD
function getPrimaryKeyField
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return primary key field for this table.
Description:  
GETPRIMARYKEYFIELDNAME
function getPrimaryKeyFieldName
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return primary key field for this table.
Description:  
GETRECORD
function getRecord
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
fieldlist Optional string [empty string]
ReturnType: query
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get a recordset based on the primary key value(s) given.
Description:  
GETRECORDS
function getRecords
Arguments:
Name Required Type Default
tablename Required string  
data Optional struct  
orderBy Optional string [empty string]
maxrows Optional numeric  
fieldlist Optional string [empty string]
advsql Optional struct  
filters Optional array  
ReturnType: query
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get a recordset based on the data given.
Description:  
GETRECORDSSQL
function getRecordsSQL
Arguments:
Name Required Type Default
tablename Required string  
data Optional struct  
orderBy Optional string [empty string]
maxrows Optional numeric  
fieldlist Optional string [empty string]
function Optional string [empty string]
advsql Optional struct  
filters Optional array  
ReturnType: array
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the SQL to get a recordset based on the data given.
Description:  
GETRELATIONTYPES
function getRelationTypes
Arguments:none
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
GETSTRINGTYPES
function getStringTypes
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return a list of datypes that hold strings / character values.
Description:  
GETSUPPORTEDDATABASES
function getSupportedDatabases
Arguments:none
ReturnType: query
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the databases supported by this installation of DataMgr.
Description:  
GETTABLEDATA
function getTableData
Arguments:
Name Required Type Default
tablename Optional string  
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return information about all of the tables currently loaded into this instance of Data Manager.
Description:  
GETTABLEPROPS
function getTableProps
Arguments:
Name Required Type Default
tablename Optional string  
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the internal table representation ready for use by DataMgr.
Description:  
GETUPDATEABLEFIELDS
function getUpdateableFields
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: array
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return an array of fields that can be updated.
Description:  
GETVERSION
function getVersion
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
GETWHERESQL
function getWhereSQL
Arguments:
Name Required Type Default
tablename Required string  
data Optional struct  
advsql Optional struct  
filters Optional array  
ReturnType: array
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
GETXML
function getXML
Arguments:
Name Required Type Default
tablename Optional string  
indexes Optional boolean false
showroot Optional boolean true
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the XML for the given table or for all loaded tables if none given.
Description:  
HASINDEX
function hasIndex
Arguments:
Name Required Type Default
tablename Required string  
indexname Required string  
ReturnType: boolean
Roles:  
Access: private
Output: false
DisplayName:  
Hint:
Description:  
INIT
function init
Arguments:
Name Required Type Default
datasource Required string  
database Optional string  
username Optional string  
password Optional string  
SmartCache Optional boolean false
ReturnType: DataMgr
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I instantiate and return this object.
Description:  
INSERTRECORD
function insertRecord
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
OnExists Optional string insert
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I insert a record into the given table with the provided data and do my best to return the primary key of the inserted record.
Description:  
INSERTRECORD2
function insertRecord2
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
OnExists Optional string insert
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I insert a record into the given table with the provided data and do my best to return the primary key of the inserted record.
Description:  
ISLOGGING
function isLogging
Arguments:none
ReturnType: boolean
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
ISSTRINGTYPE
function isStringType
Arguments:
Name Required Type Default
type Optional string  
ReturnType: boolean
Roles:  
Access: private
Output: no
DisplayName:  
Hint: I indicate if the given datatype is valid for string data.
Description:  
ISVALIDDATE
function isValidDate
Arguments:
Name Required Type Default
value Required string  
ReturnType: boolean
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
LOADTABLE
function loadTable
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I load a table from the database into DataMgr.
Description:  
LOADXML
function loadXML
Arguments:
Name Required Type Default
xmldata Required string  
docreate Optional boolean false
addcolumns Optional boolean false
ReturnType: void
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I add tables from XML and optionally create tables/columns as needed (I can also load data to a table upon its creation).
Description:  
LOGACTION
function logAction
Arguments:
Name Required Type Default
tablename Required string  
pkval Optional string  
action Required string  
data Optional struct  
sql Optional any  
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I log an action in the database.
Description:  
QUERYPARAM
function queryparam
Arguments:
Name Required Type Default
cfsqltype Optional string  
value Required any  
maxLength Optional string  
scale Optional string 0
null Optional boolean no
list Optional boolean no
separator Optional string ,
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I run the given SQL.
Description:  
QUERYROWTOSTRUCT
function queryRowToStruct
Arguments:
Name Required Type Default
query Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint: Makes a row of a query into a structure.
Description:  
READABLESQL
function readableSQL
Arguments:
Name Required Type Default
sqlarray Required array  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return human-readable SQL from a SQL array (not to be sent to the database).
Description:  
REMOVECOLUMN
function removeColumn
Arguments:
Name Required Type Default
tablename Required string  
field Required string  
ReturnType: any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I remove a column from a table.
Description:  
REMOVETABLE
function removeTable
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I remove a table.
Description:  
RUNSQL
function runSQL
Arguments:
Name Required Type Default
sql Required string  
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I run the given SQL.
Description:  
RUNSQLARRAY
function runSQLArray
Arguments:
Name Required Type Default
sqlarray Required array  
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I run the given array representing SQL code (structures in the array represent params).
Description:  
SAVERECORD
function saveRecord
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I insert or update a record in the given table (update if a matching record is found) with the provided data and return the primary key of the updated record.
Description:  
SAVERELATIONLIST
function saveRelationList
Arguments:
Name Required Type Default
tablename Required string  
keyfield Required string  
keyvalue Required string  
multifield Required string  
multilist Required string  
reverse Optional boolean false
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I save a many-to-many relationship.
Description:  
SAVESORTORDER
function saveSortOrder
Arguments:
Name Required Type Default
tablename Required string  
sortfield Required string  
sortlist Required string  
PrecedingRecords Optional numeric 0
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I save the sort order of records - putting them in the same order as the list of primary key values.
Description:  
SETCACHEDATE
function setCacheDate
Arguments:none
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
SETCOLUMN
function setColumn
Arguments:
Name Required Type Default
tablename Required string  
columnname Required string  
CF_Datatype Optional string  
Length Optional numeric 0
Default Optional string  
Special Optional string  
Relation Optional struct  
PrimaryKey Optional boolean  
AllowNulls Optional boolean true
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I set a column in the given table
Description:  
SQLCREATECOLUMN
function sqlCreateColumn
Arguments:
Name Required Type Default
field Required struct  
ReturnType: any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
STARTLOGGING
function startLogging
Arguments:
Name Required Type Default
logtable Optional string [runtime expression]
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I turn on logging.
Description:  
STOPLOGGING
function stopLogging
Arguments:none
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I turn off logging.
Description:  
TRUNCATE
function truncate
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the structure with the values truncated to the limit of the fields in the table.
Description:  
UPDATERECORD
function updateRecord
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I update a record in the given table with the provided data and return the primary key of the updated record.
Description:  
UPDATERECORDS
function updateRecords
Arguments:
Name Required Type Default
tablename Required string  
data_set Required struct  
data_where Optional struct  
filters Optional array [runtime expression]
ReturnType: void
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
METHODS
DELETE
function delete
Arguments:
Name Required Type Default
table Required string  
dataStruct Required struct [runtime expression]
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I am the generic delete functionality of the abstract gateway. I allow for very simple syntax to perform databse DELETE statements.
Description:  
GET
function get
Arguments:
Name Required Type Default
Name Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
GETAPPLICATIONIMPLEMENTATION
function getApplicationImplementation
Arguments:
Name Required Type Default
application Optional Any [empty string]
instance Optional Any [empty string]
sort Optional Any [empty string]
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
GETIMPLEMENTATION
function getImplementation
Arguments:
Name Required Type Default
id Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
INIT
function init
Arguments:
Name Required Type Default
datasource Required Any  
xmlDefinition Optional string [empty string]
ReturnType: any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
SAVE
function save
Arguments:
Name Required Type Default
table Required string  
dataStruct Required struct  
onExists Optional Any update
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I am the generic save functionality of the abstract gateway. I allow for very simple syntax to perform database INSERT / UPDATE statements. If I receive a Primary Key value, I know that I must UPDATE, otherwise, I INSERT
Description:  
SAVEAPPLICATIONIMPLEMENTATION
function saveApplicationImplementation
Arguments:
Name Required Type Default
datastruct Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
SAVEIMPLEMENTATION
function saveImplementation
Arguments:
Name Required Type Default
datastruct Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
DATASOURCE config
FILETRANSFER
component common.model.fileTransfer
FTPCONNECTION eform_34961441
METHODS
CHECKFILENAME
function checkFileName
Arguments:
Name Required Type Default
fileName Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
CLOSEFTP
function closeFTP
Arguments:none
ReturnType: void
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
COPYFTP
function copyFTP
Arguments:
Name Required Type Default
tempPath Optional Any  
sourcePath Optional Any  
destPath Optional Any  
sourceFileName Optional Any  
destFileName Optional Any  
ReturnType: string
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
COPYLOCAL
function copyLocal
Arguments:
Name Required Type Default
source Optional Any  
destination Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
CREATEFILE
function createFile
Arguments:
Name Required Type Default
filePath Optional Any  
formData Optional Any  
revision Optional Any 1
ReturnType: string
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
CREATELOCALDIRECTORYIFNOTEXISTS
function createLocalDirectoryIfNotExists
Arguments:
Name Required Type Default
LocalPath Optional Any  
ReturnType: void
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
CREATEREMOTEDIRECTORYIFNOTEXISTS
function createRemoteDirectoryIfNotExists
Arguments:
Name Required Type Default
filedirectory Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
DELETELOCAL
function deleteLocal
Arguments:
Name Required Type Default
LocalPath Optional Any  
FileName Optional Any  
ReturnType: void
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
DELETEREMOTE
function deleteRemote
Arguments:
Name Required Type Default
ftpPath Optional Any  
fileName Optional Any  
ReturnType: void
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
DIRECTORYLIST
function directoryList
Arguments:
Name Required Type Default
path Optional Any [runtime expression]
filter Optional Any [empty string]
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
DOGETDOCUMENTSOURCE
function doGetDocumentSource
Arguments:
Name Required Type Default
localPath Optional Any  
remotePath Optional Any  
fileName Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint:  
Description:  
GETDOCUMENTSOURCE
function getDocumentSource
Arguments:
Name Required Type Default
localPath Optional Any  
remotePath Optional Any  
fileName Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
INIT
function init
Arguments:
Name Required Type Default
connectionName Optional Any eform
connectionIdentifier Optional Any [runtime expression]
ReturnType: fileTransfer
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
OPENFTP
function openFTP
Arguments:
Name Required Type Default
ftpServer Optional Any [runtime expression]
ftpPort Optional Any [runtime expression]
ftpUser Optional Any [runtime expression]
ftpPass Optional Any [runtime expression]
ReturnType: struct
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
READLOCAL
function readLocal
Arguments:
Name Required Type Default
file Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
READLOCALBINARY
function readLocalBinary
Arguments:
Name Required Type Default
file Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
SAVEFILE
function saveFile
Arguments:
Name Required Type Default
remotePath Optional Any  
localPath Optional Any  
fileName Optional Any  
formData Optional Any  
ReturnType: void
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
SAVEFILELOCAL
function saveFileLocal
Arguments:
Name Required Type Default
localPath Optional Any  
fileName Optional Any  
formData Optional Any  
ReturnType: void
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
UPLOADFTP
function uploadFTP
Arguments:
Name Required Type Default
LocalPath Optional Any  
FileName Optional Any  
FilePrefix Optional Any  
FileDirectory Optional Any  
remoteFileName Optional Any [runtime expression]
ReturnType: string
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
UPLOADLOCAL
function uploadLocal
Arguments:
Name Required Type Default
FormField Optional Any  
LocalPath Optional Any  
ReturnType: string
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
ACCESS
component common.model.configuration.accessGateway
        extends common.model.baseGateway
DAO
component common.model.datamgr.DataMgr_MSSQL
        extends common.model.datamgr.DataMgr
METHODS
ADDCOLUMN
function addColumn
Arguments:
Name Required Type Default
tablename Required string  
columnname Required string  
CF_Datatype Optional string  
Length Optional numeric 50
Default Optional string  
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I add a column to the given table (deprecated in favor of setColumn).
Description:  
ADJUSTCOLUMNARGS
function adjustColumnArgs
Arguments:
Name Required Type Default
args Required struct  
ReturnType: any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
CHECKTABLE
function checkTable
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: boolean
Roles:  
Access: private
Output: no
DisplayName:  
Hint: I check to see if the given table exists in the Datamgr.
Description:  
CLEAN
function clean
Arguments:
Name Required Type Default
Struct Required struct  
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return a clean version (stripped of MS-Word characters) of the given structure.
Description:  
CONCAT
function concat
Arguments:
Name Required Type Default
fields Required string  
delimeter Optional string [empty string]
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the SQL to concatenate the given fields with the given delimeter.
Description:  
CONCATFIELDS
function concatFields
Arguments:
Name Required Type Default
tablename Required string  
fields Required string  
delimeter Optional string ,
tablealias Optional string  
ReturnType: array
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the SQL to concatenate the given fields with the given delimeter.
Description:  
CREATETABLE
function createTable
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I take a table (for which the structure has been loaded) and create the table in the database.
Description:  
CREATETABLES
function CreateTables
Arguments:
Name Required Type Default
tables Optional string [runtime expression]
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I create any tables that I know should exist in the database but don't.
Description:  
DELETERECORD
function deleteRecord
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I delete the record with the given Primary Key(s).
Description:  
DELETERECORDS
function deleteRecords
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I delete the records with the given data.
Description:  
ESCAPE
function escape
Arguments:
Name Required Type Default
name Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return an escaped value for a table or field.
Description:  
GETBOOLEANSQLVALUE
function getBooleanSqlValue
Arguments:
Name Required Type Default
value Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
GETCFDATATYPE
function getCFDataType
Arguments:
Name Required Type Default
type Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the cfqueryparam datatype from the database datatype.
Description:  
GETCREATESQL
function getCreateSQL
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the SQL to create the given table.
Description:  
GETDATABASE
function getDatabase
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the database platform being used (Access,MS SQL,MySQL etc).
Description:  
GETDATABASEDRIVER
function getDatabaseDriver
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the string that can be found in the driver or JDBC URL for the database platform being used.
Description:  
GETDATABASEPROPERTIES
function getDatabaseProperties
Arguments:none
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return some properties about this database
Description:  
GETDATABASESHORTSTRING
function getDatabaseShortString
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the string that can be found in the driver or JDBC URL for the database platform being used.
Description:  
GETDATABASETABLES
function getDatabaseTables
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get a list of all tables in the current database.
Description:  
GETDATABASEXML
function getDatabaseXml
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the XML for the given table or for all tables in the database.
Description:  
GETDATASOURCE
function getDatasource
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the datasource used by this Data Manager.
Description:  
GETDBDATATYPE
function getDBDataType
Arguments:
Name Required Type Default
CF_Datatype Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the database datatype from the cfqueryparam datatype.
Description:  
GETDBFIELDLIST
function getDBFieldList
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return a list of fields in the database for the given table.
Description:  
GETDBTABLEINDEXES
function getDBTableIndexes
Arguments:
Name Required Type Default
tablename Required string  
indexname Optional string  
ReturnType: query
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
GETDBTABLESTRUCT
function getDBTableStruct
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: array
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the structure of the given table in the database.
Description:  
GETDEFAULTVALUES
function getDefaultValues
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: struct
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
GETFIELDLENGTHS
function getFieldLengths
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return a structure of the field lengths for fields where this is relevant.
Description:  
GETFIELDLIST
function getFieldList
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get a list of fields in DataMgr for the given table.
Description:  
GETFIELDS
function getFields
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: array
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return an array of all real fields in the given table in DataMgr.
Description:  
GETFIELDSELECTSQL
function getFieldSelectSQL
Arguments:
Name Required Type Default
tablename Required string  
field Required string  
tablealias Optional string  
useFieldAlias Optional boolean true
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
GETFIELDSQL_HAS
function getFieldSQL_Has
Arguments:
Name Required Type Default
tablename Required string  
field Required string  
tablealias Optional string  
ReturnType: any
Roles:  
Access: private
Output: no
DisplayName:  
Hint:  
Description:  
GETFIELDWHERESQL
function getFieldWhereSQL
Arguments:
Name Required Type Default
tablename Required string  
field Required string  
value Required string  
tablealias Optional string  
operator Optional string =
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
GETHASFIELDSQL
function getHasFieldSQL
Arguments:
Name Required Type Default
tablename Required string  
field Required string  
tablealias Optional string  
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
GETINSERTEDIDENTITY
function getInsertedIdentity
Arguments:
Name Required Type Default
tablename Required string  
identfield Required string  
ReturnType: string
Roles:  
Access: private
Output: no
DisplayName:  
Hint: I get the value of the identity field that was just inserted into the given table.
Description:  
GETINSERTRECORDSSQL
function getInsertRecordsSQL
Arguments:
Name Required Type Default
tablename Required string  
data_set Required struct  
data_where Optional struct  
filters Optional array [runtime expression]
ReturnType: array
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
GETMAXROWSPREFIX
function getMaxRowsPrefix
Arguments:
Name Required Type Default
maxrows Required numeric  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the SQL before the field list in the select statement to limit the number of rows.
Description:  
GETMAXROWSSUFFIX
function getMaxRowsSuffix
Arguments:
Name Required Type Default
maxrows Required numeric  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the SQL after the query to limit the number of rows.
Description:  
GETMAXROWSWHERE
function getMaxRowsWhere
Arguments:
Name Required Type Default
maxrows Required numeric  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the SQL in the where statement to limit the number of rows.
Description:  
GETNEWSORTNUM
function getNewSortNum
Arguments:
Name Required Type Default
tablename Required string  
sortfield Required string  
ReturnType: numeric
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the value an increment higher than the highest value in the given field to put a record at the end of the sort order.
Description:  
GETNOWSQL
function getNowSQL
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the SQL for the current date/time.
Description:  
GETPKFIELDS
function getPKFields
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: array
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return an array of primary key fields.
Description:  
GETPKFROMDATA
function getPKFromData
Arguments:
Name Required Type Default
tablename Required string  
fielddata Required struct  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the primary key of the record matching the given data.
Description:  
GETPRIMARYKEYFIELD
function getPrimaryKeyField
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return primary key field for this table.
Description:  
GETPRIMARYKEYFIELDNAME
function getPrimaryKeyFieldName
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return primary key field for this table.
Description:  
GETRECORD
function getRecord
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
fieldlist Optional string [empty string]
ReturnType: query
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get a recordset based on the primary key value(s) given.
Description:  
GETRECORDS
function getRecords
Arguments:
Name Required Type Default
tablename Required string  
data Optional struct  
orderBy Optional string [empty string]
maxrows Optional numeric  
fieldlist Optional string [empty string]
advsql Optional struct  
filters Optional array  
ReturnType: query
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get a recordset based on the data given.
Description:  
GETRECORDSSQL
function getRecordsSQL
Arguments:
Name Required Type Default
tablename Required string  
data Optional struct  
orderBy Optional string [empty string]
maxrows Optional numeric  
fieldlist Optional string [empty string]
function Optional string [empty string]
advsql Optional struct  
filters Optional array  
ReturnType: array
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the SQL to get a recordset based on the data given.
Description:  
GETRELATIONTYPES
function getRelationTypes
Arguments:none
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
GETSTRINGTYPES
function getStringTypes
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return a list of datypes that hold strings / character values.
Description:  
GETSUPPORTEDDATABASES
function getSupportedDatabases
Arguments:none
ReturnType: query
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the databases supported by this installation of DataMgr.
Description:  
GETTABLEDATA
function getTableData
Arguments:
Name Required Type Default
tablename Optional string  
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return information about all of the tables currently loaded into this instance of Data Manager.
Description:  
GETTABLEPROPS
function getTableProps
Arguments:
Name Required Type Default
tablename Optional string  
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I get the internal table representation ready for use by DataMgr.
Description:  
GETUPDATEABLEFIELDS
function getUpdateableFields
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: array
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return an array of fields that can be updated.
Description:  
GETVERSION
function getVersion
Arguments:none
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
GETWHERESQL
function getWhereSQL
Arguments:
Name Required Type Default
tablename Required string  
data Optional struct  
advsql Optional struct  
filters Optional array  
ReturnType: array
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
GETXML
function getXML
Arguments:
Name Required Type Default
tablename Optional string  
indexes Optional boolean false
showroot Optional boolean true
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the XML for the given table or for all loaded tables if none given.
Description:  
HASINDEX
function hasIndex
Arguments:
Name Required Type Default
tablename Required string  
indexname Required string  
ReturnType: boolean
Roles:  
Access: private
Output: false
DisplayName:  
Hint:
Description:  
INIT
function init
Arguments:
Name Required Type Default
datasource Required string  
database Optional string  
username Optional string  
password Optional string  
SmartCache Optional boolean false
ReturnType: DataMgr
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I instantiate and return this object.
Description:  
INSERTRECORD
function insertRecord
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
OnExists Optional string insert
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I insert a record into the given table with the provided data and do my best to return the primary key of the inserted record.
Description:  
INSERTRECORD2
function insertRecord2
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
OnExists Optional string insert
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I insert a record into the given table with the provided data and do my best to return the primary key of the inserted record.
Description:  
ISLOGGING
function isLogging
Arguments:none
ReturnType: boolean
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
ISSTRINGTYPE
function isStringType
Arguments:
Name Required Type Default
type Optional string  
ReturnType: boolean
Roles:  
Access: private
Output: no
DisplayName:  
Hint: I indicate if the given datatype is valid for string data.
Description:  
ISVALIDDATE
function isValidDate
Arguments:
Name Required Type Default
value Required string  
ReturnType: boolean
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
LOADTABLE
function loadTable
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I load a table from the database into DataMgr.
Description:  
LOADXML
function loadXML
Arguments:
Name Required Type Default
xmldata Required string  
docreate Optional boolean false
addcolumns Optional boolean false
ReturnType: void
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I add tables from XML and optionally create tables/columns as needed (I can also load data to a table upon its creation).
Description:  
LOGACTION
function logAction
Arguments:
Name Required Type Default
tablename Required string  
pkval Optional string  
action Required string  
data Optional struct  
sql Optional any  
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I log an action in the database.
Description:  
QUERYPARAM
function queryparam
Arguments:
Name Required Type Default
cfsqltype Optional string  
value Required any  
maxLength Optional string  
scale Optional string 0
null Optional boolean no
list Optional boolean no
separator Optional string ,
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I run the given SQL.
Description:  
QUERYROWTOSTRUCT
function queryRowToStruct
Arguments:
Name Required Type Default
query Optional Any  
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint: Makes a row of a query into a structure.
Description:  
READABLESQL
function readableSQL
Arguments:
Name Required Type Default
sqlarray Required array  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return human-readable SQL from a SQL array (not to be sent to the database).
Description:  
REMOVECOLUMN
function removeColumn
Arguments:
Name Required Type Default
tablename Required string  
field Required string  
ReturnType: any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I remove a column from a table.
Description:  
REMOVETABLE
function removeTable
Arguments:
Name Required Type Default
tablename Required string  
ReturnType: any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I remove a table.
Description:  
RUNSQL
function runSQL
Arguments:
Name Required Type Default
sql Required string  
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I run the given SQL.
Description:  
RUNSQLARRAY
function runSQLArray
Arguments:
Name Required Type Default
sqlarray Required array  
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I run the given array representing SQL code (structures in the array represent params).
Description:  
SAVERECORD
function saveRecord
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I insert or update a record in the given table (update if a matching record is found) with the provided data and return the primary key of the updated record.
Description:  
SAVERELATIONLIST
function saveRelationList
Arguments:
Name Required Type Default
tablename Required string  
keyfield Required string  
keyvalue Required string  
multifield Required string  
multilist Required string  
reverse Optional boolean false
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I save a many-to-many relationship.
Description:  
SAVESORTORDER
function saveSortOrder
Arguments:
Name Required Type Default
tablename Required string  
sortfield Required string  
sortlist Required string  
PrecedingRecords Optional numeric 0
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I save the sort order of records - putting them in the same order as the list of primary key values.
Description:  
SETCACHEDATE
function setCacheDate
Arguments:none
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint:  
Description:  
SETCOLUMN
function setColumn
Arguments:
Name Required Type Default
tablename Required string  
columnname Required string  
CF_Datatype Optional string  
Length Optional numeric 0
Default Optional string  
Special Optional string  
Relation Optional struct  
PrimaryKey Optional boolean  
AllowNulls Optional boolean true
ReturnType: any
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I set a column in the given table
Description:  
SQLCREATECOLUMN
function sqlCreateColumn
Arguments:
Name Required Type Default
field Required struct  
ReturnType: any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
STARTLOGGING
function startLogging
Arguments:
Name Required Type Default
logtable Optional string [runtime expression]
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I turn on logging.
Description:  
STOPLOGGING
function stopLogging
Arguments:none
ReturnType: void
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I turn off logging.
Description:  
TRUNCATE
function truncate
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
ReturnType: struct
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I return the structure with the values truncated to the limit of the fields in the table.
Description:  
UPDATERECORD
function updateRecord
Arguments:
Name Required Type Default
tablename Required string  
data Required struct  
ReturnType: string
Roles:  
Access: public
Output: no
DisplayName:  
Hint: I update a record in the given table with the provided data and return the primary key of the updated record.
Description:  
UPDATERECORDS
function updateRecords
Arguments:
Name Required Type Default
tablename Required string  
data_set Required struct  
data_where Optional struct  
filters Optional array [runtime expression]
ReturnType: void
Roles:  
Access: public
Output: false
DisplayName:  
Hint:
Description:  
DATASOURCE config
METHODS
CHECKAUTH
function checkAuth
Arguments:
Name Required Type Default
exceptions Optional Any  
ipAddress Optional Any  
application Optional Any  
instance Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
CHECKHOST
function checkHost
Arguments:
Name Required Type Default
exceptions Optional Any  
httpHost Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
CHECKIPADDRESS
function checkIPAddress
Arguments:
Name Required Type Default
exceptions Optional Any  
ipAddress Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
DELETE
function delete
Arguments:
Name Required Type Default
table Required string  
dataStruct Required struct [runtime expression]
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I am the generic delete functionality of the abstract gateway. I allow for very simple syntax to perform databse DELETE statements.
Description:  
DELETEIPEXCEPTION
function deleteIPException
Arguments:
Name Required Type Default
id Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
DELETEPIDEXCEPTION
function deletePIDException
Arguments:
Name Required Type Default
id Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
GET
function get
Arguments:
Name Required Type Default
table Required string  
dataStruct Required struct [runtime expression]
orderBy Optional string [empty string]
limit Optional Any [empty string]
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I am the generic select functionality of the abstract gateway. I allow for very simple syntax to perform database SELECT statements.
Description:  
GETINSTANCE
function getInstance
Arguments:
Name Required Type Default
exceptions Optional Any  
ipAddress Optional Any [empty string]
httpHost Optional Any [empty string]
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
GETIPEXCEPTIONS
function getIPExceptions
Arguments:
Name Required Type Default
id Optional Any [empty string]
ipaddress Optional Any [empty string]
httphost Optional Any [empty string]
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
GETPIDEXCEPTIONS
function getPIDExceptions
Arguments:
Name Required Type Default
pid Optional Any [empty string]
applicationName Optional Any [empty string]
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
INIT
function init
Arguments:
Name Required Type Default
datasource Required Any  
xmlDefinition Optional string [empty string]
ReturnType: any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
SAVE
function save
Arguments:
Name Required Type Default
table Required string  
dataStruct Required struct  
onExists Optional Any update
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I am the generic save functionality of the abstract gateway. I allow for very simple syntax to perform database INSERT / UPDATE statements. If I receive a Primary Key value, I know that I must UPDATE, otherwise, I INSERT
Description:  
SAVEIPEXCEPTION
function saveIPException
Arguments:
Name Required Type Default
dataStruct Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
SAVEPIDEXCEPTION
function savePIDException
Arguments:
Name Required Type Default
dataStruct Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
METHODS
GETENVIRONMENT
function getEnvironment
Arguments:
Name Required Type Default
instance Optional Any  
applicationName Optional Any  
httpHost Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I look at the app + host to determine the runtime environment (dev, staging, production)
Description:  
GETPERMISSIONS
function getPermissions
Arguments:none
ReturnType: Any
Roles:  
Access: public
Output:  
DisplayName:  
Hint:  
Description:  
GETSETTINGS
function getSettings
Arguments:
Name Required Type Default
instance Optional Any  
applicationName Optional Any  
httpHost Optional Any  
environment Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I return the config only for an app+instance - I should probably be a private method
Description:  
IMPORTCONFIGFROMFILE
function importConfigFromFile
Arguments:
Name Required Type Default
file Optional Any  
instance Optional Any  
application Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
INIT
function init
Arguments:
Name Required Type Default
datasource Required string config
ReturnType: any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
INSTALLAPP
function installApp
Arguments:
Name Required Type Default
ApplicationName Optional Any  
Version Optional Any  
path Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
ISDEVELOPER
function isDeveloper
Arguments:
Name Required Type Default
pid Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
ONMISSINGMETHOD
function onMissingMethod
Arguments:
Name Required Type Default
MissingMethodName Required string  
MissingMethodArguments Required struct  
ReturnType: any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I am the missing method handler. I allow for generic use of select, save and delete. The syntax for this looks something like selectTable(id=1). The verb reflects the action, the noun reflects the table, and the arguments reflect the fields to pass to the query.
Description:  
OVERRIDEAUTH
function overrideAuth
Arguments:
Name Required Type Default
httpHost Optional Any  
ipAddress Optional Any  
application Optional Any  
instance Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
SAVESITESETTING
function saveSiteSetting
Arguments:
Name Required Type Default
datastruct Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
SETUPIMPLEMENTATION
function setupImplementation
Arguments:
Name Required Type Default
application Optional Any  
httpHost Optional Any  
ipaddress Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint:  
Description:  
SETUPSITECONFIG
function setupSiteConfig
Arguments:
Name Required Type Default
instance Optional Any  
applicationName Optional Any  
httpHost Optional Any  
ReturnType: Any
Roles:  
Access: public
Output: false
DisplayName:  
Hint: I return the configuration + environment for an app / instance
Description:  
coldfusion
struct
InstallKit Native Windows
appserver JRun4
expiration {ts '2014-04-22 02:44:30'}
productlevel Enterprise
productname ColdFusion Server
productversion 9,0,1,274733
rootdir C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfusion
supportedlocales Chinese (China),Chinese (Hong Kong),Chinese (Taiwan),Dutch (Belgian),Dutch (Standard),English (Australian),English (Canadian),English (New Zealand),English (UK),English (US),French (Belgian),French (Canadian),French (Standard),French (Swiss),German (Austrian),German (Standard),German (Swiss),Italian (Standard),Italian (Swiss),Japanese,Korean,Norwegian (Bokmal),Norwegian (Nynorsk),Portuguese (Brazilian),Portuguese (Standard),Spanish (Mexican),Spanish (Modern),Spanish (Standard),Swedish,ar,ar_AE,ar_BH,ar_DZ,ar_EG,ar_IQ,ar_JO,ar_KW,ar_LB,ar_LY,ar_MA,ar_OM,ar_QA,ar_SA,ar_SD,ar_SY,ar_TN,ar_YE,be,be_BY,bg,bg_BG,ca,ca_ES,cs,cs_CZ,da,da_DK,de,de_AT,de_CH,de_DE,de_LU,el,el_CY,el_GR,en,en_AU,en_CA,en_GB,en_IE,en_IN,en_MT,en_NZ,en_PH,en_SG,en_US,en_ZA,es,es_AR,es_BO,es_CL,es_CO,es_CR,es_DO,es_EC,es_ES,es_GT,es_HN,es_MX,es_NI,es_PA,es_PE,es_PR,es_PY,es_SV,es_US,es_UY,es_VE,et,et_EE,fi,fi_FI,fr,fr_BE,fr_CA,fr_CH,fr_FR,fr_LU,ga,ga_IE,hi_IN,hr,hr_HR,hu,hu_HU,in,in_ID,is,is_IS,it,it_CH,it_IT,iw,iw_IL,ja,ja_JP,ja_JP_JP,ko,ko_KR,lt,lt_LT,lv,lv_LV,mk,mk_MK,ms,ms_MY,mt,mt_MT,nl,nl_BE,nl_NL,no,no_NO,no_NO_NY,pl,pl_PL,pt,pt_BR,pt_PT,ro,ro_RO,ru,ru_RU,sk,sk_SK,sl,sl_SI,sq,sq_AL,sr,sr_BA,sr_CS,sr_ME,sr_RS,sv,sv_SE,th,th_TH,th_TH_TH,tr,tr_TR,uk,uk_UA,vi,vi_VN,zh,zh_CN,zh_HK,zh_SG,zh_TW
os
struct
additionalinformation [empty string]
arch amd64
buildnumber [empty string]
name Windows Server 2008 R2
version 6.1