Blog
DBX 10.1.12 Released
This update allows DBX to display included columns when enumerating indexes for tables. Based off the sp_helpindex2 stored procedure from http://www.sqlskills.com. Download from here.
Helpful Spelling Tip
Been a long time since I've posted, mostly since no one except spammers bother to come to the site, but I've finally had it and had to vent into the ether before my head explodes. For the love of all that's right and holy, the freaking word is 'lose', not 'loose'....
DBX 10.1.11 Released
A bug fix and a minor change: - fixed miscalculation of total in database/table info pane - changed sort in extended properties tab for 2005/2008 tables/views to match the ordinal position of the column
Programmatically kill a cfthread spawned from anywhere
In certain instances where you have endlessly running/sleeping 'monitoring' threads, there is effectively no way to kill them short of a CF server cycle or via the CF8 server monitor. I had this issue during development where inside an app scoped component I was...
DBX 10.1.9 Released
Minor fix in this version: - added handling for stored html content display in data sample tab
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. [crayon-6623672f1f149596008637/]
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. [crayon-6623672f1f301601300234/]