tracker issue : CF-3836702

select a category, or use search below
(searches all categories and all time range)

queryExecute leaks to the variables scope, reports incorrect value

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Raymond Camden / Raymond Camden (Raymond Camden)

Created: 10/09/2014

Components: Language

Versions: 11.0

Failure Type:

Found In Build/Fixed In Build: CF11_Final / CF11 Update5

Priority/Frequency: Major / Most users will encounter

Locale/System: English / Mac All

Vote Count: 5

Listed in the version Issues Fixed doc
As described in this SO post,, if you do

foo = queryExecute(...)

than CF's debugger service reports the query as _queryname_var0, not foo.

Also, if you have a variable called _queryname_var0, queryExecute will delete the variable from the Variables scope

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3836702

External Customer Info:
External Company:  
External Customer Name: cfjedimaster
External Customer Email:  
External Test Config: My Hardware and Environment details:



Vote by External U.
10755 | October 09, 2014 05:53:22 AM GMT
+1. Scary that this could (however unlikely) overwrite other variables. Also, query debug output needs to be readily identifiable or it's nearly useless (especially on pages where lots of queries are being executed).
Vote by External U.
10756 | October 09, 2014 09:49:03 AM GMT
+1 ......................
Vote by External U.
10757 | November 24, 2014 05:46:40 AM GMT
+1. I often look at the debug output to see how a query may have been executed. I search by query name and this destroys that ability.
Vote by External U.
10758 | December 31, 2014 09:11:01 AM GMT
The fix for this bug is available in the pre-release build of ColdFusion 11 Update 5
Comment by CFwatson U.
10753 | February 20, 2015 09:26:42 AM GMT
Verified this is fixed in CF11 Update 5 (build 11,0,05,293506). Thanks!, -Aaron
Comment by External U.
10754 | May 17, 2015 05:14:07 PM GMT
What was the actual bug? Debug output keeps logging `ExecuteQuery` instead of the assigned variable name.
Vote by Bernhard D.
10759 | June 09, 2017 08:56:01 AM GMT