Category Archives: Snippets

quick code tips for single elements, attributes, or details

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

Javascript Toggle All Checkboxes

Posted on 01/11/2012 by eSearing

Here is a nifty little tool I modified to toggle all checkboxes on a page. I use this when displaying a list of files or items that need to be processed on form submit. <SCRIPT LANGUAGE=”JavaScript”&gt //Toggle all Checkboxes function … Continue reading →

Posted in Code, Javascript, Snippets | Comments Off on Javascript Toggle All Checkboxes

CFINVOKE Passing parameters by using attribute format

Posted on 09/26/2011 by eSearing

Found this useful today: You can pass parameters in the cfinvoke tag as tag attribute name-value pairs, as the following example shows. You can also use a relative path to the CFC. <cfinvoke component=”/path/to/authQuery” method=”getAuthSecure” lastName=”#session.username#” pwd=”#url.password#” /> can also … Continue reading →

Posted in Code, Coldfusion, Snippets | Comments Off on CFINVOKE Passing parameters by using attribute format

CFLocation – URL redirection

Posted on 09/22/2011 by eSearing

There are times when it is handy to redirect to another CFM or page based upon search results. The issue I had this week was due to uninformed users not knowing which option to choose. So at the beginning of … Continue reading →

Posted in Code, Coldfusion, Snippets | Comments Off on CFLocation – URL redirection