Author Archives: eSearing

About eSearing

Webdeveloper, Photographer, political junkie.

Date Subtraction or Difference

Posted on 05/03/2012 by eSearing

Sometimes you need to know the differences between two dates in days months years whatever. SQL SERVER select datediff(day,date1, date2) as days_diff, datediff(month,date1, date2) as months_diff… Can also do year, quarter, week, hour, minute, and second dateparts. Dates can be … Continue reading →

Posted in Code, Coldfusion, Javascript, JQuery, Snippets, SQL | Tagged | Leave a comment

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 , , , | Leave a comment

New Website – HonestAutoQuote.com

Posted on 04/19/2012 by eSearing

I built a new website for a long time client. Check out HonestAutoQuote.com if you need a fast free honest auto insurance quote. There are no gimmicks, no promises of freebees like 1 in 100 wins a gift card, and … Continue reading →

Posted in my portfolio, News | Leave a comment

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 | Leave a comment

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 | Leave a comment