Entries for 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 more...

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 more...

Powered by Mango Blog.