Adventures in bad variable names

There are many built-in, always-there variable scopes in CF, including #cgi#, #form#, #url#, etc., and one does well to avoid using these names for anything other than their intended purpose. However, I was doing a CFHTTP call (in CF8) and set the result attribute to...

DBX 10.1.8 Released

Minor update in this version: when launching the SQL*Exec window from the table or view detail page, the populated sql now has the columns [bracketed] (by request) increased the default size of the textarea in the SQLExec window since although its actually sizable by...

DBX 10.1.7 Released

Changes in this version: – added explicit identification of SQL2008 (would previously fail with ‘unsupported version’) – fixed stylesheet references when printing tabs While I don't have an available SQL2008 instance to test against, to the...

CF-style List functions in SQL Server

The built-in string handling functions in t-sql are all well and good, but there really aren’t any graceful ways of handling lists. As any CF developer that’s been around a while knows, lists are pretty commonplace in practice, and there are times when it makes more sense (or you’re required) to do list handling at the db level rather than at the front end.