Status/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): Aaron Neff / Aaron Neff (Aaron Neff)
Created: 02/25/2016
Components: Documentation
Versions: 2016
Failure Type: Unspecified
Found In Build/Fixed In Build: CF2016_Final /
Priority/Frequency: Trivial / Some users will encounter
Locale/System: English / Platforms All
Vote Count: 0
https://helpx.adobe.com/coldfusion/developing-applications/accessing-and-using-data/using-query-of-queries/query-of-queries-user-guide.html says:
--------------------------------------------
Managing complex objects
You cannot use Query Of Queries on a recordset that contains complex objects, such as arrays and structures.
--------------------------------------------
That is not true. QoQ can be used on recordsets containing complex objects. Repro:
<cfscript>
q1 = queryNew("a", "varchar", [["a"]]);
q2 = queryNew("b,c,d,e", "object,object,object,integer", [[q1, ["foobar"], {foo="bar"}, 1]]);
q3 = queryExecute("SELECT * FROM q2 WHERE e = 1", [], {dbtype="query"});
writeDump(q3);
</cfscript>
Actual and expected result: No error thrown (good). Confirmed in CF11 Update 7 and CF2016.
Thus, that entire "Managing complex objects" section should be removed from the docs.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 4121949
External Customer Info:
External Company:
External Customer Name: Aaron Neff
External Customer Email:Attachments:
Comments: