Category Archives: Code

Coldfusion cfoutput grouping

Posted on 08/09/2010 by eSearing

The cfoutput tag has a group attribute that lets you group your data for reports. The outer most cfoutput must have the query name and the group but the inner groups can not have the query name. In the following … Continue reading →

Posted in Code, Coldfusion, Snippets, SQL | Comments Off on Coldfusion cfoutput grouping

JQuery DatePicker Plugin

Posted on 08/06/2010 by eSearing

I had the need for a calendar datepicker in a recent project and could not use Coldfusion’s input datefield. I am building the form on the fly and loading form elements from a database using a CFC and a bunch … Continue reading →

Posted in Code, Javascript, JQuery, Problems & Fixes | Comments Off on JQuery DatePicker Plugin

Javascript User entry validation

Posted on 07/23/2010 by eSearing

I have a form with an ID input box. If the id is less than 6 characters i want to disable the submit button until it reaches the 7th character. What I found was that users sometimes Type their id, … Continue reading →

Posted in Code, Javascript, Problems & Fixes, Snippets | Comments Off on Javascript User entry validation

CSS – page break and dont print

Posted on 07/23/2010 by eSearing

Found this little CSS tidbit useful to day. I had output order entry records with multiple page detail. I wanted each page of the detail to print to its own sheet. The problem I faced was that the Top of … Continue reading →

Posted in Code, CSS | Comments Off on CSS – page break and dont print

SQL – Performance issues with UPPER or lower case

Posted on 07/21/2010 by eSearing

Assume you have a large database with millions of records. One of the columns is an id number made of upper and lower case letters, numbers, and other symbols. And to make it easy on your users you merely convert … Continue reading →

Posted in Code | Comments Off on SQL – Performance issues with UPPER or lower case