{"id":380,"date":"2010-09-14T16:04:17","date_gmt":"2010-09-14T20:04:17","guid":{"rendered":"http:\/\/erics-test-lab.com\/?p=380"},"modified":"2010-09-14T16:04:17","modified_gmt":"2010-09-14T20:04:17","slug":"coldfusion-result-attributes","status":"publish","type":"post","link":"https:\/\/www.esearing.com\/v2010\/2010\/09\/coldfusion-result-attributes\/","title":{"rendered":"coldfusion result attributes"},"content":{"rendered":"

During my exploration of the previous article I needed to view the SQL statement that was being dynamically generated.
\nFortunately Coldfusion has add the “result” attribute to cfquery. This allows you to see things like execution time, sql, sql arguments, etc…<\/p>\n

<cfquery name=\"q\" datasource=\"myDSN\" result=\"rq\">>
\nselect * from #mytable#
\nwhere source = #sourcesel#
\n<\/cfquery>
\n...
\n<cfdump var=\"#rq#\">
\nYields all the info about the query stored in the result set.
\n...
\n<cfoutput>#rq.sql# <\/cfoutput>
\nyields the SQL only
\n \"select * from theRealTableName where source= 200\"
\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"

During my exploration of the previous article I needed to view the SQL statement that was being dynamically generated. Fortunately Coldfusion has add the “result” attribute to cfquery. This allows you to see things like execution time, sql, sql arguments, … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,16,24],"tags":[],"class_list":["post-380","post","type-post","status-publish","format-standard","hentry","category-code","category-coldfusion","category-snippets-quick-code-tips-for-single-elements-attributes-or-details"],"_links":{"self":[{"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/posts\/380","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/comments?post=380"}],"version-history":[{"count":0,"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/posts\/380\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/media?parent=380"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/categories?post=380"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esearing.com\/v2010\/wp-json\/wp\/v2\/tags?post=380"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}