the singularity of being and nothingness
Archive for May, 2012
Gloss Updated with ColdFusion 10 Documentation
May 16th
On the heels of yesterdays’s official release of ColdFusion 10, I’ve updated Gloss with support for both ColdFusion 10 AND ColdFusion 9 reference guides.
Enjoy!
Share this:ColdFusion Bug? EntityToQuery() and Unknown Data Type
May 2nd
I ran into an interesting issue today. To make a long story a little less uninteresting, I was basically trying to go from an array of ORM entities to an Excel dump of the data in those entities. Obviously, the easiest way to accomplish this is to first convert the array of entities to a query, and then pass the query result set off to the built-in CF Excel manipulation functions.
Easy enough. With one little line of code, you can very simply convert ORM entities to a ColdFusion query…just like so:
// get the orm entities ormstuff = EntityLoad( "Art" ); // convert the orm goodness to a CF query anicequery = EntityToQuery( ormstuff );
Cake, right? If I were to hand this query off to CF’s spreadsheet functions, I could easily prepare and export a nice Excel file full of the data I just converted. But of course, nothing is that simple…and that’s where the potential bug announced itself.
A Dark ForebodingYou see, instead of simply dumping all the data for all the columns of the query-which-was-once-an-entity, I wanted to pare down the list of columns that would be output in the Excel export. Since I already had a query handy, More >