Archive for category Programming

Spry Proof-of-Concept

Posted by me in JavaScript, Programming on May 14th, 2010

I’ll post details later, but basically this uses Adobe Labs’ Spry AJAX framework to process a single xml file. The goal was to provide a searchable catalog from a single file. The plan is to augment this with catalog images, more data to search and maybe even a pretty interface.
I will say that Adobe could’ve [...]

No Comments

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

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

Oracle Function to Create CFQuery

Posted by me in ColdFusion, Oracle on March 10th, 2009

Rather than creating insert and update queries in ColdFusion against an Oracle database, this function can generate the code for you. I haven’t added cfqueryparam to check the datatypes, but that would be ideal at helping prevent SQL Injection attacks.

No Comments

Oracle Function to Create CFForm

Posted by me in ColdFusion, Oracle on March 10th, 2009

If you use table and column comments, you can create an Oracle function that will create insert and update forms for you complete with table formatting and data type form fields that are limited to the number of chars in a column.

No Comments