Jim Land
Use cfinclude sparingly.
- Avoid a nightmare like this (real-life example): A page, which includes another page that runs a query, then includes yet another page which loops over the query results, and then includes another page, which includes some text from a text file.
Stamp every record in the database with the creation date/time and who created it.
Make every primary key a value that will never change.
- Make it an autonumber integer, a unique identifier, or similar. Never a number that really means something, such as partnumber, or accountnumber, or ssn.