Callable

Class

DataFaucet 1.0 Beta

FRAMES

datafaucet.system.sql
Class insert

WEB-INF.cftags.component
        datafaucet.system.sql.duck
            datafaucet.system.sql.simplefiltergroup
                datafaucet.system.sql.filtergroup
                    datafaucet.system.sql.statement
                        datafaucet.system.sql.insertablestatement
                            datafaucet.system.sql.insert

public class insert
extends insertablestatement
extends insertablestatement

creates a sql insert statement - this statement is not filtered and can not be unioned or joined

Constructor Summary
`init(string table, [struct insertdata='[runtime expression]'], [any datasource=''])`

Method Summary
`any`	`execute()`
`any`	`filter()` it's easier for other components to use the insert object if it merely ignores filters rather than producing an error
`string`	`getSyntax()`
`any`	`setNull(string columnList)`

Methods inherited from class datafaucet.system.sql.insertablestatement
`getColumn, increment, incrementDate, setColumn, set_insertData`

Methods inherited from class datafaucet.system.sql.statement
`addListener, bindFilters, broadcast, clearJoinTables, clearListeners, clearUnions, getColumnList, getColumns, getDatasource, getGroupSource, getListeners, getNewListener, getSQLAgent, getSource, getSourceName, getTable, get_alias, hasFilters, hasGroupSource, hasJoinTables, hasListeners, initStatement, notifyListener, reset, setDatasource, set_datasource, set_table`

Methods inherited from class datafaucet.system.sql.filtergroup
`addLiquidFilterGroup, addLiquidFilters, andOrCollectionFilter, andOrFilter, caseSensitiveFilter, collectionFilter, dateFilter, filterGroup, filterLanguage, filterLocale, getDefaultLocale, getLiquidNameArray, getLocaleArray, getNewFilter, listFilter, nullFilter, numericFilter, onMissingMethod, reverseFilter, setFirstFilter, sqlFilter, timeSpanFilter`

Methods inherited from class datafaucet.system.sql.simplefiltergroup
`appendFilter, clearFilters, columnNotFoundException, filtersExist, getAvailableColumnList, getFilters, getFirstFilter, getTableArray, getTableForColumn, get_column, hasJoinSource, isGroup, makeFilters, raiseFilterExceptions, setTable, typeMismatchException`

Methods inherited from class datafaucet.system.sql.duck
`arg, getDefaultLocalization, getLocalization, getNext, getObject, getProperties, getProperty, getPropertylist, getTail, getValue, hasNext, identifyAccessorOrMutator, insertAfter, parseDate, parseNumber, raiseAbstractClassException, raiseMissingMethodException, removeAfter, setLocalization, setNext, setProperties, setProperty, setValue, simplify`

Methods inherited from class WEB-INF.cftags.component

Constructor Detail

init

public init(string table, [struct insertdata='[runtime expression]'], [any datasource=''])

Parameters:: table - the database table to insert a record into; insertdata - a collection of data for insert / update operations; datasource

Method Detail

execute

public any execute()

Overrides:: execute in class statement

filter

public any filter()

it's easier for other components to use the insert object if it merely ignores filters rather than producing an error

getSyntax

public string getSyntax()

Overrides:: getSyntax in class statement

setNull

public any setNull(string columnList)

Parameters:: columnList

Overview

Package