Dumping out the SQL from a query object, even more so if it’s been passed around through some functions, can be a pain. Usually you can wrap the query in a CFDUMP and call it a day, however for very large queries or if you want it more concise use this
<queryname>.getMetaData().getExtendedMetaData().sql
Eric Stevens
I am a senior developer at Infinite Web Design.
Latest posts by Eric Stevens (see all)
- Test and deploy HAProxy Config - May 18, 2017
- Stopping Exchange 2016 Same Domain Spam Spoofing - August 12, 2016
- Gulp Watch After Windows Restart - April 1, 2016
