Callable

Class

DataFaucet 1.0 Beta

FRAMES

datafaucet.system.sql
Class datefilter

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

public class datefilter
extends simplefiltergroup
extends simplefiltergroup

filters a query with a specified column before or after a specified date or within/not within a specified date range

Constructor Summary
`init(string column, [string after=''], [string before='1'], [boolean bindFilters='true'], [any table=''])`

Method Summary
`private string`	`get_column()`
`boolean`	`hasFilters()`
`private void`	`makeFilters()`
`private any`	`newFilter(datafaucet.system.sql.date content, string comparison)`
`private void`	`setDate(string propertyname, string propertyvalue)`
`any`	`setProperties(struct collection)`
`private void`	`set_after(string propertyname, string propertyvalue)`
`private void`	`set_before(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 after=''], [string before='1'], [boolean bindFilters='true'], [any table=''])

Parameters:: column - the name of a column to filter results on; after - the earliest possible date to return from the query; before - 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(datafaucet.system.sql.date content, string comparison)

Parameters:: content; comparison

setDate

private void setDate(string propertyname, string propertyvalue)

Parameters:: propertyname; propertyvalue

setProperties

public any setProperties(struct collection)

Overrides:: setProperties in class duck

Parameters:: collection

set_after

private void set_after(string propertyname, string propertyvalue)

Parameters:: propertyname; propertyvalue

set_before

private void set_before(string propertyname, string propertyvalue)

Parameters:: propertyname; propertyvalue

Overview

Package