Dynamically sorting by a column in a Stored Procedure (SQL Server)
Have you ever needed to build a stored procedure that would take the name of a column as a parameter, and return the results ordered by that column? So have…
ColdFusion Caching Explained
Configured in the ColdFusion administrator under the "Caching" section, server caching controls how much and when data is stored in memory. An effective server caching strategy can relieve stress on…
SQL – Select using current day…
I've had this problem a few times, and many people always ask me it... so here it is immortalised. If you require to select all records added to your table…
Email – Multipart Email with HTML/Plaintext
It is often quite usefull to be able to send an email with HTML for those that can support it, and Plaintext, for those who do not. There is how…