Callable

Class

DataFaucet 1.0 Beta

FRAMES

datafaucet.system.sql
Class update

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.update

public class update
extends insertablestatement
extends insertablestatement

creates a sql update statement which can be filtered - update statements can not be unioned or joined

Constructor Summary
`init(string table, [struct insertdata='[runtime expression]'], [boolean insertnulls='false'], [boolean insert], [string setnull=''], [any datasource=''])`

Method Summary
`any`	`execute()`
`string`	`getSyntax()`
`any`	`setNull(string columnList, [boolean overwrite='true'], [boolean append='true'])`

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, filter, 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]'], [boolean insertnulls='false'], [boolean insert], [string setnull=''], [any datasource=''])

Parameters:: table - the database table to insert a record into; insertdata - the data to insert into the database; insertnulls - indicates if null values should be inserted for columns not represented in the insert structure; insert - indicates if a record should be inserted if no matching record is found in the database; setnull - a comma delimited list of columns to set null during update; datasource

Method Detail

execute

public any execute()

Overrides:: execute in class statement

getSyntax

public string getSyntax()

Overrides:: getSyntax in class statement

setNull

public any setNull(string columnList, [boolean overwrite='true'], [boolean append='true'])

Parameters:: columnList; overwrite; append

Overview

Package