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

T-SQL function to get a char count

I needed an efficient and reusable way to get character counts in strings at the database level and produced the following udf which takes a string and a character and returns the number of occurrences of the character in the string. CREATE FUNCTION...

T-SQL function to get word count

Similar in approach to the previous uf_charCount function, the following function returns the number of words in a string, assuming a space token as word separator. CREATE FUNCTION [dbo].[uf_wordCount] (@string varchar(8000)) RETURNS SMALLINT /* Purpose: returns the...

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