by websolete | Nov 25, 2008 | ColdFusion
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...
by websolete | Nov 18, 2008 | SQL Server
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...
by websolete | Nov 18, 2008 | SQL Server
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...
by websolete | Nov 18, 2008 | ColdFusion, DBX, SQL Server
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...
by websolete | Nov 11, 2008 | ColdFusion, DBX, SQL Server
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...
