Monthly Archives: June 2010

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

Limitations of the Job

Posted on 06/01/2010 by eSearing

I was chatting with a freshman college student over the weekend about paths of study and potential future jobs. It got me to thinking about my past, present, and future work. I have worked in retail sales ,for a large … Continue reading →

Posted in Randomness | Comments Off on Limitations of the Job