Viewing by month: January 2009
cfselect, binding, and selectedvalues
ColdFusion's cfselect doesn't support the selectedvalue argument when using binding. I don't like the JavaScript solutions out there, so here's a simple SQL solution.Read complete post
Proximity searching in sql server
Just need to keep track of this for future ussage. After a bunch of googling this was the clearest example of doing a proximity search in SQL Server that I could find.
implementing a proximity search in sql server
(Via Googling.)
Filling date gaps in a report
I needed a way to push a bunch of blank dates into a query for a cfchart to ensure I didn't have any gaps in my date coverage. This article did the trick...Read complete post