Callable

Class

DataFaucet 1.0 Beta

FRAMES

datafaucet.system.sql
Class filter

WEB-INF.cftags.component
        datafaucet.system.sql.duck
            datafaucet.system.sql.filter

public class filter
extends duck
extends duck

applies a filter to any sql statement object

Constructor Summary
`init(string column, any content, [string comparison], [string include], [string delimiters], [boolean dynamic='false'], [boolean reverse='false'], [boolean casesensitive='false'], [any table=''])`

Method Summary
`any`	`getDatasource()`
`any`	`getTable()`
`private string`	`get_column()`
`boolean`	`isGroup()`
`any`	`setTable(any table)`
`private any`	`set_column(string propertyname, string propertyvalue)`
`private void`	`set_compare(string propertyname, string propertyvalue)`
`private void`	`set_dynamic(string propertyname, boolean propertyvalue)`
`private void`	`set_reverse(string propertyname, boolean propertyvalue)`
`private void`	`set_table(string propertyname, any propertyvalue)`

Methods inherited from class datafaucet.system.sql.duck
`arg, getDefaultLocalization, getLocalization, getNext, getObject, getProperties, getProperty, getPropertylist, getTail, getValue, hasNext, identifyAccessorOrMutator, insertAfter, onMissingMethod, 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 column, any content, [string comparison], [string include], [string delimiters], [boolean dynamic='false'], [boolean reverse='false'], [boolean casesensitive='false'], [any table=''])

Parameters:: column - the name of a column to filter results on; content - the content to compare against the data stored in the table; comparison - indicates how the content of the current filter should be compared against the database (<|=|>|like|in|not in|null|not null) - defaults to 'like' for varchar columns or = for all other data types; include - and / or -- determines whether the filters are cumulative or exclusive; delimiters - a list of delimiters if the compare attribute is in or not in; dynamic - indicates that the content argument is a string of arbitrary SQL; reverse - indicates that the filter should be reversed, checking for the column value within the content string; casesensitive - indicates that the content of columns should not be made case-insensitive for databases with case-sensitive collation; table - an object of type statement.cfc

Method Detail

getDatasource

public any getDatasource()

getTable

public any getTable()

get_column

private string get_column()

isGroup

public boolean isGroup()

setTable

public any setTable(any table)

Parameters:: table - an object of type DataFaucet.sql.statement

set_column

private any set_column(string propertyname, string propertyvalue)

Parameters:: propertyname; propertyvalue

set_compare

private void set_compare(string propertyname, string propertyvalue)

Parameters:: propertyname; propertyvalue

set_dynamic

private void set_dynamic(string propertyname, boolean propertyvalue)

Parameters:: propertyname; propertyvalue

set_reverse

private void set_reverse(string propertyname, boolean propertyvalue)

Parameters:: propertyname; propertyvalue

set_table

private void set_table(string propertyname, any propertyvalue)

Parameters:: propertyname; propertyvalue

Overview

Package