DataFaucet ORM

Numeric Filter

A numeric filter is a convenient way of filtering content between two numeric values. A numeric filter is specified with one column name and two content values - a minimum and a maximum.

Example:

<cfscript>
  // get the datasource
  ds = request.DataFaucet.getDatasource(); 
  // create a select statement 
  stmt = ds.getSelect("*","tblProduct product"); 
  
  // filter by price range 
  stmt.numericFilter("productprice",form.minprice,form.maxprice);
  
  // get the results 
  query = stmt.execute(); 
</cfscript>