DataFaucet 1.0 Beta

Package datafaucet.system.sql

Class Summary
andorcollectionfilter filters a query using a collection (typically form input) to generate and-or filters for each column indicated in the collection
andorfilter applies a collection of and/or keyword filters to a specified set of columns
collectionfilter filters a query using the contents of a structure (usually form input)
datefilter filters a query with a specified column before or after a specified date or within/not within a specified date range
delete creates a sql delete statement which can be filtered - delete statements can not be unioned or joined
duck provides basic functionality for other sql objects
filter applies a filter to any sql statement object
filtergroup provides a means of manually attaching grouped filters to statement object - extended by insert, update and select statements
insert creates a sql insert statement - this statement is not filtered and can not be unioned or joined
insertablestatement extended by insert and update to manage insert data
linkedlist creates a linked-list object -- several of these objects can be chained together to create a sortable memory-resident structure which is passed by reference
numericfilter 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
procedure stores parameters for execution of a specified stored procedure
select creates a sql select statement which can be unioned, joined and filtered
simplefiltergroup an abstract class which is extended by filtergroup.cfc and other grouped-filters
statement provides an additional interface for declaring and executing abstracted SQL-queries
timespanfilter filters a query to provide results where one time-span overlaps or does not overlap another time-span
update creates a sql update statement which can be filtered - update statements can not be unioned or joined
DataFaucet 1.0 Beta