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 th... (more)