Deleting duplicate rows in Oracle

2009 August 06
No Comments
tags: Code · Oracle
by Nick

Every so often it seems I need to delete duplicated rows in a table. I usually first turn to Google to find a solution only to waste 10-15 minutes finding the right approach that doesn't overcomplicate the process by generating temp tables and such.

read more...

Web Service Caching

2009 June 15
No Comments
tags: ColdFusion
by Nick

Be careful with ColdFusion caching your Web Service WSDL, added methods may not appear to be accessible and could cause errors.

read more...

Explicit FarCry webroot mapping

2009 May 18
No Comments
tags: FarCry · ColdFusion
by Nick

I ran into a problem regarding path mappings on FarCry although I think this issue could surface on any project. I couldn't figure out why I was getting File Not Found errors for uploaded files and images.

read more...

Delete all User tables in Oracle

2009 April 22
No Comments
tags: Oracle
by Nick

I was looking for a quick way to drop all tables for a user from SQL Developer and came across the following tip which I wanted to make a note of as I'm sure it will be useful in the future.

read more...

Twitterific crashing on my iPhone

2008 December 04
No Comments
tags: iPhone
by Nick

I was having a problem getting the Twitterific iPhone app to work today. Everytime I tried to open it, the splash screen would display for a couple of seconds, and then the app would just close, taking me back to the home screen.

After restarting a couple of times, I thought to delete it and reinstall from the app store… and what do you know, that fixed it. Was slighty annoying, but only took a minute to reinstall.

CF8 Upgrade Gotchas

2008 June 03
No Comments
tags: ColdFusion
by Nick

Since upgrading to ColdFusion 8 last week on my staging server at work, I've come across a few gotchas that I wanted to put down on record for future reference...

 

read more...

cffile problem on Unix

2008 February 06
No Comments
tags: ColdFusion
by Nick

I was working with some legacy code on a Unix server recently and kept running into a permissions error... The cleanup process of this particular task would fail with the message: "Delete" cannot be performed. The problem was with a cffile tag:

read more...

[unknown type] Errors When Parsing Valid XML

2008 February 05
tags: ColdFusion · Code
by Nick

There's nothing more aggravating than the ambiguous java.lang.NullPointerException when debugging CF (and Java) apps.

read more...

VMWare on Mac

2008 January 28
tags: Apple · Software
by Nick

Ok, so it's a little over a week now since I've been using my MacBook and so far, so good. I have been able to use it exclusively for work. I've come across only a couple minor issues that have been no problem to overcome, but most importantly, I haven't had to the need to use my PC.

Regardless of this, I bought VMWare Fusion and just completed the installation of Windows XP Pro on a virtual machine. I thought this would be good to use for setting up a development environment as well as having Windows handy in case I do need it for anything.

read more...

Encapsulating Front-End Logic with Tag Libraries

2008 January 24
No Comments
tags: ColdFusion · Code
by Nick

Creating modular display logic has always been somewhat of a challenge... there are many different approaches to take, and it's hard to determine which will be the most flexible and maintainable in the long run. I've always been accustomed to coding all my display templates so that all variables are within the attributes scope. This allows any template to be called using <cfmodule>, allowing it to either run on its own, or allowing required parameters to be passed in.
In addition, (following the FuseBox practice of copying all URL and Form variables to the attributes scope so that you have a universal variable scope. For me, this makes sense because it ensures consistency; no matter how my front-end templates are called, the proper variables can be available.

read more...