Author Archives: eSearing

About eSearing

Webdeveloper, Photographer, political junkie.

Using CF IIF with Javascript Functions

Posted on 06/16/2010 by eSearing

I get bored writing CFIF statements so thought I would try using the old IIF method. Despite the arguments about performance it works quite well if you are not running it through thousands of iterations. I also had need to … Continue reading →

Posted in Code, Coldfusion, Snippets | Comments Off on Using CF IIF with Javascript Functions

Books

Posted on 06/13/2010 by eSearing

Buying computer books is a bit of a waste of money since their information is relatively out of date in a couple of years. So recently I purchased some of sitepoints books digitally when they went on sale. I find … Continue reading →

Posted in Coldfusion, Products | Comments Off on Books

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