PaulHobson.com

I don’t understand why ColdFusion insists on making things difficult. I’ve come to understand that it is not possible for ColdFusion to make use of inherent input arrays when one or more input elements is left empty. For some reason ColdFusion always drops the empty values from the array. I can’t think of any possible [...]

I have a love/hate relationship with Coldfusion. (Okay, so it’s more hate than love) But one of the aspects of the programming language that I have come to love is it’s simplicity with dealing with regular expressions. Using predefined methods such as reFind() and reReplace() have made task, which could have been overly frustrating, very [...]

I’m tired of google-ing for a good Coldfusion string stripping reference, so I’ve found what I believe to be the most efficient way accomplishing this task (ala Regular Expressions) and am posting them here for my own reference. If these can help anyone else out in the process… great!

<!— // Strip everything except numbers and [...]

The problem:
I need to grab both column labels and row values from my database based on nothing more than a passed table name. Getting the data is easy, and getting the column labels is easier thanks Coldfusion’s variable attributes but it isn’t quite what I want.

The cfquery results attribute “.columnList” returns the table’s column [...]