Developing a data-entry interface for managing pesky lookup tables can be a
laborious task for even the most seasoned CF developer. These tables usually
include a few simple data fields - an identity column for use as a primary
key, a text descriptor and perhaps some ancillary information that needs to
be managed through a Web-based data-entry interface.
Single template editing (STE) is a methodology for combining insert, update
and delete actions in a single .cfm file. While some coding strategies
(Fusebox) may increase the number of files required to perform a data-entry
task, this method seeks to minimize files by combining functionality.
Once I had optimized the STE algorithm down to the fewest possible lines of
code, I created a studio template file to help author these interfaces.
Despite using the template, I was still spending an average of 45 minutes
develo... (more)