SQL Joins

Having spent most of my career working in environments where SQL development and ColdFusion development are handled by separate people or teams. The end result is that my SQL skills are not as evolved as my ColdFusion skills.

At my current job I am the one who writes the SQL for the small and medium-sized ColdFusion & SQL Server-based systems that I develop. Up until the other day I used implicit inner joins and over-used subqueries to get the data that I wanted from a database. My code worked, but it was ugly.

Read the rest of this entry »

Code Formatting

I’m checking out WP-Syntax, a WordPress plugin that makes short work of sharing code samples…

1
2
3
4
5
6
7
8
9
10
11

<cfscript>
   variables.cheeses = StructNew();
   variables.cheeses.Gouda = CreateObject("component", "Cheese").init(
      datasource="cheesyDB",
      name="Gouda"
      );
</cfscript>
 
<cfoutput>
   #variables.cheeses.Gouda.getDescription()#
</cfoutput>

If anyone has any tips for modding WP-Syntax or an alternative solution feel free to drop me a comment.

Shell

My first pet project is “Shell”, a simple O-O ColdFusion Sample Application. I’ve spent about 90 minutes on it at this point (translation: it’s not done), so consider it more of a “sketch” at this point.

Shell – Version 0.0.0.1b (pardon the hokey over-use of the shell metaphor in the code).

ColdFusion Rules

Hi everyone.  After a few years of taking a devoting a majority of my free time to studying photography I’ve decided to start a new code-focused blog. I’ll be posting my thoughts and code samples on ColdFusion (my favorite language), Flash, JavaScript (AJAX, YUI), SQL, CSS, Accessibility and anything else that inspires me in the world of software development.

I’ll also be pimping out this (or possibly another) WordPress theme as time allows.