Entries for month: January 2009

cfselect, binding, and selectedvalues cfselect, binding, and selectedvalues 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 more...

Proximity searching in sql server Proximity searching in sql server 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 Filling date gaps in a report 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 more...

Powered by Mango Blog.