ColdFusion Sentence Case

Posted by me in ColdFusion on March 18th, 2010

I wanted to normalize text entered by users so that I could collect stats. So I SQL’d something like this…
select count(1) as total, upper(nvl(resp,’NO RESPONSE’)) as resp from forms.form_field_resp where ffid=#id# group by upper(nvl(resp,’NO RESPONSE’)) order by total desc
But I didn’t want to display the text in all CAPS BECAUSE THAT’S PRETTY DANG ANNOYING. So [...]

No Comments

This I Believe, Part I

Posted by me in Personal on October 27th, 2009

Prologue:
I’ve been meaning to write this for a long time. The first time I can remember that someone asked me what do I believe, I honestly didn’t know the answer. Sure, I could have recited some verse or creed from my Lutheran childhood, but I know that was not an entirely accurate portrait of my [...]

No Comments

Classics from my Childhood

Posted by me in Personal on August 17th, 2009

I thought I’d round up a few of my fondest childhood television moments for you to laugh at or enjoy.

No Comments

Log Mining in Oracle 10g

Posted by me in Oracle on July 19th, 2009

If you ever had to perform log mining in Oracle prior to 10g, you will be pleasantly surprised by how easy and fast it is in 10g. After using 10g for several years, I finally got a chance to use log miner in 10g. Until now, flashback queries were always enough to recover errant deletes [...]

No Comments

Ideas Waiting For Reality

Posted by me in Thinking on May 24th, 2009

I’d like to present you with a few ideas for products that might make life a little bit easier: the skimmer sock, the floating fire pit, laptop legs and the scanner shredder.

No Comments