I needed a dummy query for a page I was working on the other day, which caused me to sigh with grief. Everyone knows what a pain creating dummy queries using queryNew()/queryAddRow()/querySetCell() can be, even for a simple query with one row. Thus I decided not to bother and simply used a "real" query with a real datasource and a "select" statement but no "from" clause. This worked nicely, so I decided to expand on this and utilize the nested implicit structure and array creation that was fixed in ColdFusion 8.0.1 to create a UDF that would allow me to create a query in two lines of code.

At least a year ago I was asked to create a means of accessing reporting data within Connect (which I think was still transitioning from being Breeze at the time). I posted about it figuring few if any people actually cared to use it. Nonetheless, someone was interested but was hoping to use the API for creating users and meetings which relied on methods I had not yet implemented. Thankfully, every request to the Connect API is very similar and I had built a means of easily adding new method implementations into the component (some of them are just a few lines), so it didn't take long to actually add it (and I say "not long" in terms of actual hours...it did take me forever to find the time to get around to it).