Category Archives: SQL

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

Penny Rounding

Posted on 06/04/2010 by eSearing

Rounding issues are the bane of every accountants existence. While a few records may only produce a few cents difference a few million records can lead to thousands of dollars or just a penny. Depending on if the rounding occurs … Continue reading →

Posted in Code, Snippets, SQL | Comments Off on Penny Rounding

Get last record inserted without primary key or id

Posted on 06/03/2010 by eSearing

Sometimes we need to get the last record inserted into the database. But if there is no primary key, date, or ID field to query we can use a temp table to return the results we need. Example: Table MY_CONTACTS … Continue reading →

Posted in Code, Snippets, SQL | Comments Off on Get last record inserted without primary key or id

SQL order by required

Posted on 06/02/2010 by eSearing

There are subtle differences between Oracle, Sybase, mySQL, and SQL Server SQL syntax. Sybase seems to be the most forgiving or loose while Oracle’s and MS SQL Server’s syntax is very strict.

Posted in Code, SQL | Comments Off on SQL order by required

CFMail Tracker – Application

Posted on 05/27/2010 by eSearing

Seems like CFMail goes wonky every once in a while and decides not to work. The administrators always blame it on too much mail for the server to handle. So I decided to call them on their “theory” and build … Continue reading →

Posted in Code, Coldfusion, Problems & Fixes, SQL | Comments Off on CFMail Tracker – Application