This one has bugged me for a long time. ColdFusion allows you to build SQL statements dynamically (using variables, expressions, conditions, and more), but have you ever wanted to know exactly what that final generated SQL was? ColdFusion obviously knows what it is, and if you have debugging turned on then it gets displayed (I even wrote a UDF to return the SQL string, but it only works if debugging is turned on), but thus far it has never been exposed to us developers. Well, this should be changing in Blackstone, along with RecordCount and ColumnList and ExecutionTime, there’ll be additional data exposed, including the final SQL statement. (Note that I said “should”, not “will”).
Yet another example of one of the many infrequently discussed goodies in the works.
Leave a Reply