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.


  // get the datasource
  ds = request.DataFaucet.getDatasource(); 
  // create a select statement 
  stmt = ds.getSelect("*","tblProduct product"); 
  // filter by price range 
  // get the results 
  query = stmt.execute();