Data should be consistent. State abbreviations, phone numbers, title prefixes, dates – they should all be stored in your database in a consistent manner. But don’t use ColdFusion to enforce consistency. Yes, it is easy to use UCase() and other functions to manipulate the data, but that it is not efficient, nor will your code be used if data is inserted into a database using another client. The right way to enforce data consistency is on the database itself – using triggers or stored procedures. (Applies to: ColdFusion All)

Leave a Reply