Using Saved Queries in the Query Builder

If you "save" the query instead (either by using the left-most icon at the top of the query builder or by simply closing the query builder once you've created or modified one), this saved query is presented in a list of all such queries that have been saved for the given datasource (presented below the list of tables for that datasource, as shown in the database tab). You can then drag and drop such a saved query onto your CFML code.

You can also change a saved query by double-clicking on it in the just-mentioned list of saved queries. Note, however, that once a query is dropped into your code, it will not be affected by changes made to the saved query. Similarly, to be sure, changes made to the query in the CFML code will have no impact on any saved query from which it was created.

Charlie Arehart
Education Director, Fig Leaf Software

© 2008 SYS-CON Media