Latest Posts

Permanent Solution to an old Problem

Posted on December 31, 2007, under ColdFusion, SQL Server | 3347 Views

One of the rare issues came up today where I need to extract the date only from a datetime field. I remembered part of it but still had to google for a second to get the other pieces. Now, I'm posting the syntax here so I don't have to go hunting for i ...

read more »



MD5 Function SQL Server

Posted on February 25, 2005, under SQL Server | 14717 Views

The Code Project - MD5 Hash SQL Server Extended Stored Procedure - Database I needed to insert data hashed with MD5 into a sql db. Coldfusion has a procedure builtin to handle that called hash() but I also want to ensure that data inserted from other s ...

read more »