displaying top 100 results
Tracker Issue Improve scalar functions in query of query
Improve scalar functions in query of query
Tracker Issue Improve scalar functions in query of query
Improve scalar functions in query of query
Comment on Improve scalar functions in query of query by External U.
Comment on Improve scalar functions in query of query by External U.
Comment on Improve scalar functions in query of query by External U.
Comment on Improve scalar functions in query of query by External U.
Comment on Improve scalar functions in query of query by External U.
Comment on Improve scalar functions in query of query by External U.
Comment on Improve scalar functions in query of query by External U.
Comment on Improve scalar functions in query of query by External U.
Comment on Improve scalar functions in query of query by Rupesh K.
Comment on Improve scalar functions in query of query by External U.
Comment on Improve scalar functions in query of query by External U.
Comment on Improve scalar functions in query of query by External U.
Comment on Improve scalar functions in query of query by External U.
Comment on Improve scalar functions in query of query by External U.
Map, Reduce, and Filter functions in a query object in ColdFusion
Portal Topic Unioning queries using query of query
Dave Ferguson Unioning queries using query of query Here is how you can union together two queries using query of query. This function would take two queries and use query of query to combine them into a single query. The code below assumes the columns from the two source queries are identical. You
Comment on Enable "spreadsheet to query" for functions by External U.
Comment on Enable "spreadsheet to query" for functions by External U.
Tracker Comment Comment on Bug 75399:(Watson Migration Closure)The newly introduced query() function doesn't allow us building Query of queries by Nimit S.
Comment on Bug 75399:(Watson Migration Closure)The newly introduced query() function doesn't allow us building Query of queries by Nimit S.
3804410 CF-4200408 Carl V. Bug is in the core query-of-query functionality, not just query.cfc.
Comment on Enable "spreadsheet to query" for functions by Vamseekrishna N.
Comment on Remove Query.cfc functions as it's broken and won't be fixed by Aaron N.
Tracker Issue cfgrid: query bind is failing
/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36
Remote Address 127.0.0.1
Referrer
Date/Time 15-Dec-14 05:22 PM
Stack Trace
at cfcal2ecfm37157720.runPage(C:/inetpub/cf11/cal.cfm:7)
coldfusion.runtime.QueryFunction$Query
Replacing QueryConvertForGrid with Window functions and Common Table Expressions
Remove Query.cfc functions as it's broken and won't be fixed
Comment on Remove Query.cfc functions as it's broken and won't be fixed by James M.
Tracker Issue Argument is not treated as a struct by Query functions
Argument is not treated as a struct by Query functions
Comment on Query data type should support keyExists member function by Awdhesh K.
Comment on Remove Query.cfc functions as it's broken and won't be fixed by John W.
Comment on Enable "spreadsheet to query" for functions by External U.
Comment on Remove Query.cfc functions as it's broken and won't be fixed by James M.
Comment on Enable "spreadsheet to query" for functions by External U.
Tracker Issue Enable "spreadsheet to query" for functions
Enable "spreadsheet to query" for functions
ColdFusion incorrectly executes custom functions named queryExecute()
Tracker Comment Comment on Bug in Query.cfc by Nimit S.
2596901 CF-3486277 Nimit S. This is now possible with QueryExecute function in ColdFusion 11.
SauravGhosh CFFiddle for Flow control tags and a few more functions Picking up from where we left off on updating the docs with CFFiddle links, we have now extended the links to the following tag and function categories: File functions Query functions Decision functions Data output functions Flow
Introduce queryGetResult() for the corresponding member function, query.getResult()
2610301 CF-3712128 Language Adam Cameron Other type-centric member functions should be implemented G'day:
As well as a transliteration of the procedural type-specific functions (eg: queryNew(), querySetCell() into member functions, other functionality like toJson(), dump(), toWddx() should
Tracker Comment Comment on queryExecute - Add Map function by External U.
Comment on queryExecute - Add Map function by External U.
Tracker Issue Query.sort() does not return the sorted query
2673661 CF-4119099 Language Adam Cameron Query.sort() does not return the sorted query See http://blog.adamcameron.me/2016/02/coldfusion-2016-query-iteration.html
Member functions should return the result, not act on the original object. The function should not alter the original it should simply
2843197 CF-4198333 Language : Functions Henry Ho queryNew rowData attribute does not accept coldfusion.runtime.ArgumentCollection Problem Description:
queryNew rowData attribute does not accept a struct with java type coldfusion.runtime.ArgumentCollection
Steps to Reproduce:
function test(arg1
Tracker Comment Comment on Cannot clear query cache by Adobe D.
clears the cache data before executing the second query
If there is any additional information you can provide us to reproduce the bug, it would be helpful
Note: We might deprecate the tag in future.
Use of removeCachedQuery function is recommended over tag
Details of this function is in the link
4223283 CF-4202044 Language : Member Functions [ANeff] Bug for: Aether missed correcting some member functions Issues:
1) array.clear() returns modified array (good), but struct.clear() returns boolean (bad)
2) query.deleteColumn() and query.deleteRow() return modified query (good), but:
2a) query
Tracker Comment Comment on queryExecute - Add Map function by Vamseekrishna N.
Comment on queryExecute - Add Map function by Vamseekrishna N.
Tracker Issue String member functions don't cast
String member functions don't cast
Tracker Comment Comment on ColdFusion incorrectly executes custom functions named queryExecute() by Dan S.
Comment on ColdFusion incorrectly executes custom functions named queryExecute() by Dan S.
Tracker Comment Comment on Provide more fully featured version of Query of Queries (QoQ). Support more functions by External U.
Comment on Provide more fully featured version of Query of Queries (QoQ). Support more functions by External U.
Tracker Comment Comment on Provide more fully featured version of Query of Queries (QoQ). Support more functions by External U.
Comment on Provide more fully featured version of Query of Queries (QoQ). Support more functions by External U.
Tracker Comment Comment on Provide more fully featured version of Query of Queries (QoQ). Support more functions by External U.
Comment on Provide more fully featured version of Query of Queries (QoQ). Support more functions by External U.
Tracker Comment Comment on Provide more fully featured version of Query of Queries (QoQ). Support more functions by Aaron N.
Comment on Provide more fully featured version of Query of Queries (QoQ). Support more functions by Aaron N.
Tracker Comment Comment on Provide more fully featured version of Query of Queries (QoQ). Support more functions by Jack D.
Comment on Provide more fully featured version of Query of Queries (QoQ). Support more functions by Jack D.
Tracker Comment Comment on String member functions don't cast by Immanuel N.
2608121 CF-4187503 Immanuel N. With ColdFusion preserving datatypes, member functions can be invoked on values that are strings.
The following snippet now returns "11", with sampleQuery.ID.len() and Len(sampleQuery.ID) not returning exceptions.
{code:java}
sampleQuery = QueryNew( "ID
Tracker Comment Comment on Introduce queryGetResult() for the corresponding member function, query.getResult() by External U.
Comment on Introduce queryGetResult() for the corresponding member function, query.getResult() by External U.
Tracker Issue Map|reduce|sort methods on query objects
2609274 CF-3863003 Language : Functions On behalf of Adam cameron Map|reduce|sort methods on query objects Problem:Map|reduce|sort methods on query objects
Method: Added support for each(), filter() (Bug: 3713323).
Evaluate and add support for map(), reduce() methods on query objects as well
Tracker Comment Comment on queryExecute - Add Map function by External U.
Comment on queryExecute - Add Map function by External U.
We should change the member function name from Query.swap() to Query.rowSwap
Tracker Comment Comment on [ANeff] Bug for: Aether missed correcting some member functions by Suchika S.
4223283 CF-4202044 Suchika S. We have added the support for Query.AddRow, Query.Addcolumn, Query.SetCell functions. We have not added structObj.clear because it will cause the bug ,CF-4201614.
Tracker Comment Comment on Introduce queryGetResult() for the corresponding member function, query.getResult() by External U.
Comment on Introduce queryGetResult() for the corresponding member function, query.getResult() by External U.
Add cachedUntil option to query-related tags and functions
Please add some additional functionality to query of queries in upcoming versions
Tracker Issue Docs for query iteration methods missing sections
2673659 CF-4119107 Documentation Adam Cameron Docs for query iteration methods missing sections EG: https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-functions/functions-m-r/queryfilter.html (and same applies to map, each, sort, reduce)
These pages are missing the category, history
2610279 CF-3713323 Rupesh K. we have already added the support for each and filter for query. We are keeping this bug open for map and reduce functions for query.
Tracker Comment Comment on Single quotes inside of MSSQL comments cause issues with cfparam by Benjamin M.
4780558 CF-4203307 Benjamin M. So the QueryExecute function did not cause this issue to occur under the same circumstances. It seems to only be in the query object. Our development team prefers to use the query object over the QueryExecute function, so it is likely we will maintain our own fix
Tracker Comment Comment on cfloop over a function local scope query ends iteration early by Vamseekrishna N.
Comment on cfloop over a function local scope query ends iteration early by Vamseekrishna N.
Tracker Comment Comment on cfloop over a function local scope query ends iteration early by External U.
Comment on cfloop over a function local scope query ends iteration early by External U.
Tracker Comment Comment on cfloop over a function local scope query ends iteration early by External U.
Comment on cfloop over a function local scope query ends iteration early by External U.
Tracker Comment Comment on Add cachedUntil option to query-related tags and functions by External U.
Comment on Add cachedUntil option to query-related tags and functions by External U.
Tracker Comment Comment on ColdFusion incorrectly executes custom functions named queryExecute() by Dan S.
Comment on ColdFusion incorrectly executes custom functions named queryExecute() by Dan S.
Tracker Comment Comment on ColdFusion incorrectly executes custom functions named queryExecute() by Suchika S.
Comment on ColdFusion incorrectly executes custom functions named queryExecute() by Suchika S.
Tracker Comment Comment on Error with queryName.removeRows function when using CachedWithin parameter when creating query by External U.
Comment on Error with queryName.removeRows function when using CachedWithin parameter when creating query by External U.
Tracker Comment Comment on Please add some additional functionality to query of queries in upcoming versions by Vamseekrishna N.
Comment on Please add some additional functionality to query of queries in upcoming versions by Vamseekrishna N.
Tracker Comment Comment on Please add some additional functionality to query of queries in upcoming versions by External U.
Comment on Please add some additional functionality to query of queries in upcoming versions by External U.
Tracker Comment Comment on Please add some additional functionality to query of queries in upcoming versions by External U.
Comment on Please add some additional functionality to query of queries in upcoming versions by External U.
Tracker Comment Comment on Provide more fully featured version of Query of Queries (QoQ). Support more functions by External U.
Comment on Provide more fully featured version of Query of Queries (QoQ). Support more functions by External U.
Tracker Comment Comment on Provide more fully featured version of Query of Queries (QoQ). Support more functions by Aaron N.
Comment on Provide more fully featured version of Query of Queries (QoQ). Support more functions by Aaron N.
Tracker Issue QueryFilter mutates the original query
QueryFilter mutates the original query
2608693 CF-4022420 External U. Oh, and these:
Query.every(Function): returns true if all rows in the query fulfills the test. ALl collections should have this method.
Query.filter(String): where String is an SQL WHERE clause, and query and clause are passed to the QoQ engine. Maybe call this Query
Tracker Comment Comment on Bug 74797:(Watson Migration Closure)Please allow chaining of Query() methods: by Nimit S.
2602151 CF-3037173 Nimit S. Please use queryExecute function introduced in ColdFusion 11.
We have stopped making any enhancements to query.cfc
Tracker Comment Comment on Having one single quote in a multi-line style comment in a script based query breaks params. by Nimit S.
2609792 CF-3769705 Nimit S. QueryExecute() function has been introduced in ColdFusion 11 which addresses this issue.
Tracker Issue Bug 82839:Function QueryConvertForGrid used to pad the query for CFGRID with empty rows in CF8
Bug 82839:Function QueryConvertForGrid used to pad the query for CFGRID with empty rows in CF8
Tracker Comment Comment on Unscoped vars in Query.cfc by Nimit S.
2672575 CF-4186779 Nimit S. Its a valid bug but there is no active development on these CFCs and we recommend to use QueryExecute function. So closing this issue.
Please let us know if you face any issue related to QueryExecute.
Tracker Issue [ER]: Decision Member functions Support
[ER]: Decision Member functions Support
2609975 CF-3740141 Core Runtime Aaron Neff [ANeff] Bug for: Outer query loop mangles inner grouped query loop A grouped query loop gets mangled if wrapped w/ another query loop
Steps to reproduce:
1) Run this:
#type#:
#name#
Expected Output:
tag: cfif cfset
function: now len
Actual
Iterator methods for queries not available as member functions.