Callable

Class

DataFaucet 1.0 Beta

FRAMES

datafaucet.system.sql
Class numericfilter

WEB-INF.cftags.component
        datafaucet.system.sql.duck
            datafaucet.system.sql.simplefiltergroup
                datafaucet.system.sql.numericfilter

public class numericfilter
extends simplefiltergroup
extends simplefiltergroup

filters a query with a specified column greater or less than a specified minimum or maximum number or within/not within a specified numeric range

Constructor Summary
`init(string column, [string min=''], [string max=''], [boolean bindFilters='true'], [any table=''])`

Method Summary
`private string`	`get_column()`
`boolean`	`hasFilters()`
`private void`	`makeFilters()`
`private any`	`newFilter(numeric content, string comparison)`
`private void`	`setNumber(string propertyname, string propertyvalue)`
`any`	`setProperties(struct collection)`
`private void`	`set_max(string propertyname, string propertyvalue)`
`private void`	`set_min(string propertyname, string propertyvalue)`

Methods inherited from class datafaucet.system.sql.simplefiltergroup
`appendFilter, bindFilters, clearFilters, columnNotFoundException, execute, filtersExist, getAvailableColumnList, getDatasource, getFilters, getFirstFilter, getGroupSource, getSource, getSyntax, getTable, getTableArray, getTableForColumn, hasGroupSource, hasJoinSource, hasJoinTables, isGroup, raiseFilterExceptions, setTable, typeMismatchException`

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, setProperty, setValue, simplify`

Methods inherited from class WEB-INF.cftags.component

Constructor Detail

init

public init(string column, [string min=''], [string max=''], [boolean bindFilters='true'], [any table=''])

Parameters:: column - the name of a column to filter results on; min - the earliest possible date to return from the query; max - the latest possible date to return from the query - a number may be substituted to indicate a specific number of days; bindFilters - indicates if the created filters should be grouped; table - an object of type statement.cfc

Method Detail

get_column

private string get_column()

Overrides:: get_column in class simplefiltergroup

hasFilters

public boolean hasFilters()

Overrides:: hasFilters in class simplefiltergroup

makeFilters

private void makeFilters()

Overrides:: makeFilters in class simplefiltergroup

newFilter

private any newFilter(numeric content, string comparison)

Parameters:: content; comparison

setNumber

private void setNumber(string propertyname, string propertyvalue)

Parameters:: propertyname; propertyvalue

setProperties

public any setProperties(struct collection)

Overrides:: setProperties in class duck

Parameters:: collection

set_max

private void set_max(string propertyname, string propertyvalue)

Parameters:: propertyname; propertyvalue

set_min

private void set_min(string propertyname, string propertyvalue)

Parameters:: propertyname; propertyvalue

Overview

Package