Ray Camden has put up a very nice post about pulling the actual text of a ColdFusion query. I’ve been playing around with ColdFusion 8 in my dev environment and one of the things I miss most when going back to a 7 server is the text of the SQL in the <cfdump> for the query.
Go read the article for a more thorough explanation bust basically there are two ways to see the text of a query.
- Add the ‘result=yourstruct’ attribute to your query tag and a bunch of meta data about the query will be put in yourstruct
- Call the function getMetaData() on the query and you’ll get a bunch of information about the column names and types of the query
The full article explains a lot more about the two approaches. This is a great tip especially when you don’t have access to a server’s administration application.
- Tags: ColdFusion, Query
About this blog
My name is Dan Cramer. I’ve been working at TheraDoc for the past 4 years as a Software Developer. Most recently I’ve been doing a lot of application development using ColdFusion, ColdBox, jQuery, YUI and a bunch of other stuff. This notebook has been setup to document the stuff that I find so that 2 months(weeks) down the road when I forget what I’ve done, I can come back and look at it. And if it helps someone else in the process, then that’s just gravy.
Leave a reply