<p>I found some very strange behaviour of ColdFusion’s query component. When you use this component to build a query of query (QoQ) of another ColdFusion Query and use order by on several colums, the last column in the order by list is added to the selected output. This appears to happen in CF9, 10, 11 and 2016, but not in Lucee. /* Create an unsorted CF-query */ unsorted = QueryNew("col1,col2,col3,col4","VarChar,VarChar,Integer,VarChar"); for (a=10;a gte 1;a--){ QueryAddRow(unsorted); QuerySetCell(unsorted,"col1","col1 #a#"); QuerySetCell(unsorted,"col2","col2 #a#"); QuerySetCell(unsorted,"col3","#a#"); […]</p>
<p>The post <a rel="nofollow" href="https://coldfusion.adobe.com/2017/12/query-component-bug-returns-extra-column/">Query component bug returns extra column</a> appeared first on <a rel="nofollow" href="https://coldfusion.adobe.com">ColdFusion</a>.</p>
Labels:
cfquery, Discussion, Language, bug, cfml tag/function, ColdFusion, language, major, major bug, of, queries, query, query of queries
Comments: