CFQuery – metadata
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 [...]



Recent Comments