You learn something new everyday! I Just discovered that in Coldfusion 7 you can get query infomation (metadata) by adding result = ‘aVariable’ to the cfquery tag.

for example:

select * from aTable

The resulting dump shows:

CACHED (boolean)
COLUMNLIST (the names of the columns returned)
EXECUTIONTIME (time to execute query ms)
RECORDCOUNT (rows returned)
SQL (the sql that was executed)

I use it [...]

Over at Mike schierberl’s blog I discoved his Varscoper Tool.
This is a great utility for us function writers as it allows you to plug in a file (cfc or cfm) and it will inspect the functions inside to see if you have missed any local variables from the VAR scope.
I hope mike doesn’t mind, but [...]

I know of a few people that like to scope all their variables and I know a few that don’t.
Personally I scope all of my variables depending on the type they are.For instance:

The reason I do this is so that I can dump out my qry struct (that holds all my queries) to [...]

The Transact SQL Case statement is a particularly useful piece of syntax to know as it can be used to solve many potentially tricky SQL Server programming tasks without resorting to more computationally intensive procedures such as using cursors, temporary tables or processing of the results set in a programming. One such use is to [...]

As a developer I’ve been using Fusebox since it first appeared as a very viable framework.It hasn’t taken long for it to develop into the leading framework of choice for Coldfusion Developers, but its latest incarnation Fusebox 4 and the very new Fusebox 5, hasn’t taken to the mainstream. Why is this?
Well mainly because there [...]