Monthly Archives: April 2012

SQL using case to Identify blanks vs NULLs

Posted on 04/27/2012 by eSearing

I had a strange issue driving me nuts today. I had data with null values and could use isNull to capture most of them and assign a new value to the field. However about 10 records would not accept the … Continue reading →

Posted in Code, Snippets, SQL | Tagged , , , | Comments Off on SQL using case to Identify blanks vs NULLs

Coldfusion CFC error messages

Posted on 04/13/2012 by eSearing

CFC’s are a wonderful thing in the world of Coldfusion Apps. They allow you append/display information without refreshing the page, deliver realtime queries of data, or display messages when users require guidance. They are wonderful until they break. If you … Continue reading →

Posted in Coldfusion, Problems & Fixes | Comments Off on Coldfusion CFC error messages

Coldfusion Query of Queries to Join two datasets

Posted on 04/12/2012 by eSearing

I had an issue where I needed to join data from two different datasets with out having an ODBC connection created by the admin. I ran the two queries in thier respective databases then used query of queries to join … Continue reading →

Posted in Code, Coldfusion, Snippets | Comments Off on Coldfusion Query of Queries to Join two datasets