The purpose of the QuerySim is to remove the design and population of a database from the critical path of application development. This is very useful since it allows a developer to write and test code that relies on a query before any of the database work is done. When the database is complete, simply change the connect string to point to the real database and replace the QuerySim text with a SQL select statement that returns the appropriate columns.
The QuerySim is especially useful when following the FLiP methodology for Fusebox (www.fusebox.org) application development, but you can benefit from QuerySims even if you are not using FLiP or Fusebox!
The syntax of the ColdFusion QuerySim custom tag is:
<CF_QuerySim>
QueryName
ColumnName1,ColumnName2,ColumnName3
DataValue1|DataValue2|DataValue3
</CF_QuerySim>
The time consuming task of creating a QuerySim is populating the data values with sample data. QuerySim Generator eliminates this task by walking you through a simple process to create a QuerySim. It automatically populates the data rows within the QuerySim to save you time in generating sample data. After the sample data rows are generated, you simply copy and paste the code created by QuerySim Generator into your application. Click here to begin!
