QueryMill 2.0™ is a highly configurable, thin-client solution for providing web-based database querying capabilities to your users. Using QueryMill's powerful administration tools, you can create customized end-user query interfaces quickly and easily. Implemented as a custom tag, this flexible tool can easily be used in a wide range of applications, and it can be adapted readily for use in dynamic environments with heterogeneous data sources.

QueryMill™ uses a two-stage approach to the query process. The first step is for an administrator to generate a "query definition." A query definition defines the tables and columns which are available to an end user. The second part of QueryMill is the end user interface - the actual generation of queries. Here the user enters their query criteria and specifies the columns to be included in their result set. The two major components of QueryMill are described below. You can also try them for yourself on the corresponding tabs on this site.

Query Administration Interface

• Define and edit query definitions
• Specify the data source for each query definition
• Specify optional HTML or ColdFusion templates to include as headers or footers in result display
• Use provided default results display template, or specify a custom ColdFusion template
• Specify tabs to allow grouping of query criteria
• Select tables to include in each query definition. Specify syntax for joining tables.
• Select columns to be used as query criteria
• Specify how each query column will be presented (e.g. text, radio buttons, check boxes, drop down, multi-select)
• Define lookup lists for easy criteria input
• Select columns which will be available for inclusion in query results
• Assign user-friendly names to tables and columns
• Define links (including data from query results) to appear in result set

End-User Interface

• Wizard steps user through process of defining how they want to query and display data
• Users can define queries based on tables and columns within a query definition
• Users can select the columns to display in query results, as well as specifying column order
• Users can specify sort columns, breaks, and aggregation for query results
• Users can save - and optionally share - customized queries (consisting of query criteria and result columns, sorting, etc.)

System Requirements

• Internet Explorer 4.0+ or Netscape Communicator 3.0+ (for Administrators and End Users)
• ColdFusion Professional 4.5.1 or higher (on server)
• Web Server
• Works with any ODBC or OLE-DB data source.