displaying top 100 results
Tracker Comment Comment on Please add more built-in closure functions: Array/Struct/List/QueryMap, Array/Struct/List/QueryReduce by External U.
Comment on Please add more built-in closure functions: Array/Struct/List/QueryMap, Array/Struct/List/QueryReduce by External U.
Tracker Comment Comment on Please add more built-in closure functions: Array/Struct/List/QueryMap, Array/Struct/List/QueryReduce by External U.
Comment on Please add more built-in closure functions: Array/Struct/List/QueryMap, Array/Struct/List/QueryReduce by External U.
Tracker Issue Map|reduce|sort methods on query objects
Map|reduce|sort methods on query objects
Map, Reduce, and Filter functions in a query object in ColdFusion
Comment on Map|reduce|sort methods on query objects by External U.
Comment on Map|reduce|sort methods on query objects by External U.
Tracker Comment Comment on Please add more built-in closure functions: Array/Struct/List/QueryMap, Array/Struct/List/QueryReduce by External U.
Comment on Please add more built-in closure functions: Array/Struct/List/QueryMap, Array/Struct/List/QueryReduce by External U.
Tracker Comment Comment on Please add more built-in closure functions: Array/Struct/List/QueryMap, Array/Struct/List/QueryReduce by Suchika S.
Comment on Please add more built-in closure functions: Array/Struct/List/QueryMap, Array/Struct/List/QueryReduce by Suchika S.
Comment on Map|reduce|sort methods on query objects by External U.
Tracker Comment Comment on Please add more built-in closure functions: Array/Struct/List/QueryMap, Array/Struct/List/QueryReduce by External U.
Comment on Please add more built-in closure functions: Array/Struct/List/QueryMap, Array/Struct/List/QueryReduce by External U.
Comment on Map|reduce|sort methods on query objects by External U.
Comment on Map|reduce|sort methods on query objects by External U.
Tracker Comment Comment on Please add more built-in closure functions: Array/Struct/List/QueryMap, Array/Struct/List/QueryReduce by External U.
Comment on Please add more built-in closure functions: Array/Struct/List/QueryMap, Array/Struct/List/QueryReduce by External U.
Comment on Map|reduce|sort methods on query objects by Immanuel N.
Comment on Map|reduce|sort methods on query objects by External U.
Comment on Map|reduce|sort methods on query objects by External U.
Tracker Comment Comment on Add Support for Map/Reduce/Filter/Each Functions for Query Objects by External U.
Comment on Add Support for Map/Reduce/Filter/Each Functions for Query Objects by External U.
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 Issue Please add more built-in closure functions: Array/Struct/List/QueryMap, Array/Struct/List/QueryReduce
Please add more built-in closure functions: Array/Struct/List/QueryMap, Array/Struct/List/QueryReduce
Portal Topic Quick Tip: Returning a query as an array of structures in ColdFusion 2018 using reduce() and the fat arrow operator
Quick Tip: Returning a query as an array of structures in ColdFusion 2018 using reduce() and the fat arrow operator
.where() instead? Is there further scope for Query.select(), Query.join(), Query.groupBy(), Query.orderBy() too?
Query.reduceRight(): all collections should have this method. Same as .reduce(), but starts from the last element, not the first.
Query.some(Function): returns true if a row in the query fulfills
Tracker Comment Comment on Iterator methods on query objects have not been implemented by Immanuel N.
2610279 CF-3713323 Immanuel N. This fix addresses support for query.each() and query.filter().
map() and reduce() will be addressed as part of fix for bug #CF-3863003.
Comment on Map|reduce|sort methods on query objects by External U.
Tracker Comment Comment on queryExecute - Add Map function by Vamseekrishna N.
2608510 CF-4073770 Vamseekrishna N. We will be adding map and reduce member functions on query object as part of #CF-3713323
Comment on Map|reduce|sort methods on query objects by External U.
Tracker Comment Comment on Iterator methods on query objects have not been implemented by Immanuel N.
2610279 CF-3713323 Immanuel N. The scope of this bug is limited to inclusion of each() and filter() methods for query objects.
Support for map, reduce and sort will be addressed in bug CF-3863003.
Tracker Issue make queries implement an array interface
. Well, not as a method. It would be good to have an OO way of creating a query though, without falling back to queryNew().
Query.prepend(): adds rows (/another query) to the front of a query.
Query.reduce(): should already have been implemented.
Query.set(): possibly use .filter() and .insert
Tracker Comment Comment on Add Support for Map/Reduce/Filter/Each Functions for Query Objects by External U.
Comment on Add Support for Map/Reduce/Filter/Each Functions for Query Objects by External U.
2610279 CF-3713323 Language Adam Cameron Iterator methods on query objects have not been implemented There should be each(), filter(), map(), reduce() methods on query objects as well (as per arrays, structs, lists)
--
Adam
----------------------------- Additional Watson Details
Comment on Map|reduce|sort methods on query objects by Immanuel N.
Comment on Map|reduce|sort methods on query objects by External U.
Add Support for Map/Reduce/Filter/Each Functions for Query Objects
Tracker Comment Comment on Add Support for Map/Reduce/Filter/Each Functions for Query Objects by External U.
Comment on Add Support for Map/Reduce/Filter/Each Functions for Query Objects by External U.
Tracker Comment Comment on Add Support for Map/Reduce/Filter/Each Functions for Query Objects by External U.
Comment on Add Support for Map/Reduce/Filter/Each Functions for Query Objects by External U.
Comment on Converting an array of structs to a query dynamically by David Byers
.toArray(), or queryGetRows(theQuery[,startRow,endRow])/theQuery.getRows([startRow,endRow]), to return array of structs
Workarounds:
array function queryToArray(required query query) {
return ARGUMENTS.query.reduce(function(result, row) {return result.append(row);}, []);
}
-or-
array function query
Tracker Comment Comment on Add Support for Map/Reduce/Filter/Each Functions for Query Objects by External U.
Comment on Add Support for Map/Reduce/Filter/Each Functions for Query Objects by External U.
aliaspooryorik
@Jeff Coughlin Thanks for your comment, I’m aware of the data parameter for QueryNew. I didn’t use that here as you need to know the columns in advance before you can pass in the array. So sure, I could have used arrayReduce to find all the fields names, then used that do
Portal Topic More Modern CFML features
daniel fredericks More Modern CFML features More Modern features in ColdFuison, what are these features? Here are some and examples for each: CFScript QueryExecute Member Functions Elvis Operator Colusures Map Reduce Filter Each First Class Functions Safe Navigator CFScript: Seems like first
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
setColumnNames method not working on query introduced by hotfix 5
Tracker Comment Comment on Add Support for Map/Reduce/Filter/Each Functions for Query Objects by External U.
Comment on Add Support for Map/Reduce/Filter/Each Functions for Query Objects by External U.
Tracker Comment Comment on Iterator methods on query objects have not been implemented by Awdhesh K.
Comment on Iterator methods on query objects have not been implemented by Awdhesh K.
Tracker Comment Comment on coldfusion application server crashes on clear query cache by External U.
Comment on coldfusion application server crashes on clear query cache by External U.
Tracker Comment Comment on [ANeff] ER for: Array notation to respect query cell data type for simple values by Aaron N.
Comment on [ANeff] ER for: Array notation to respect query cell data type for simple values by Aaron N.
Tracker Comment Comment on [ANeff] ER for: DeserializeJSON() support for .toJSON()'s serializeQueryByColumns="struct" by Aaron N.
Rows) && queryRows.len() && isStruct(queryRows[1])) {
//Begin determining query column names
var queryColumns = queryRows.reduce(function(queryColumns, queryRow) {
if(isStruct(queryRow)) {
var possibleColumns = ARGUMENTS.queryRow.keyArray();
var newColumns = possible
Tracker Issue [ANeff] Bug for: CF-3863003 hidden
6125504 CF-4205059 Language : Member Functions [ANeff] Bug for: CF-3863003 hidden Issue: CF-3863003 hidden
CF-3863003 was fixed in CF2016 Final but is hidden in the tracker.
CF2016's description is: "Support map|reduce|sort methods on query objects"
That should be visible in the tracker
just rewrote your code (facepalm).
accumulator = "";
columns = data.reduce(function(accumulator, item) {
item.each(function(key) {
if (!listFind(accumulator, key)) {
accumulator = listAppend(accumulator, key);
}
});
return accumulator;
});
writeDump(query
Tracker Comment Comment on Enhance cfquery or anything that returns queries to return array of structs by External U.
2608475 CF-4085682 External U. At World Singles we've switched away from query results completely to arrays of structs and it's not only faster, it's much more convenient since you can then leverage all the normal map / filter / reduce stuff along with regular array and struct functions
Tracker Comment Comment on poor error handling when neo-cron.xml is corrupted or truncated by External U.
to complete. It may also be linked with SQL locking errors.
What I have tried to do is to rewrite queries that update tables to reduce the number or records being updated and thus the time a specific query runs. This appears to have been successful but it may be that the ColdFusion server (CF11 Update 5
6896483 CF-4207473 Language Unexpected result when setting inline struct inside function call that's inside a CFIF/CFELSE that's inside a CFOUTPUT query loop Problem Description:
This is such a specific set of circumstances that it's difficult to isolate what the exact cause is or reduce
Tracker Issue String methods process single quotes differently when CFSet is used inside a CFQuery block
or ReplaceList is used with the assignments, leading to the assumption that most (if not all) string methods are similarly affected.
For purposes of this example, the query was reduced to a no-op to show that the query itself is not the problem. In the original case, the method used was 'Replace
Tracker Issue String member functions don't cast
2608121 CF-4187503 Language brian king String member functions don't cast Problem Description:
.len() .trim() and other "string"-based member functions should cast values that are 'stringy" but not objects as string just as Len() and Trim() do now, to reduce confusion in code. When used on values
Comment on make queries implement an array interface by External U.
Tracker Issue Security scanner SQLi odd guidance
it not be the other way around? And obviously neither is actually a problem.
And apparently queryExecute() is not vulnerable in these ways, as I get no notifications on those statements.
I have to ask... is this feature ready for testing yet? Should I just leave it be?
Note: I am not specifically trying to defeat
Portal Comment Comment on Alternatives to Query of Query by Charlie Arehart
Comment on Alternatives to Query of Query by Charlie Arehart
Tracker Comment Comment on Unescaped query.column as struct key name yields unexpected results by Poonam J.
Comment on Unescaped query.column as struct key name yields unexpected results by Poonam J.
Tracker Comment Comment on Error Executing Database Query. Timed out trying to establish connection by External U.
Comment on Error Executing Database Query. Timed out trying to establish connection by External U.
Tracker Comment Comment on Named param replacement by Chris H.
2609035 CF-3943345 Chris H. Have had a similar Issue in CF11 Update 12 but only when using a crap ton of parameters - was the fix only for a certain amount of digits?
CF CODE (reduced, not full code) - loops about 500 times to produce 1k params (large update)
note that the last digit of the dump
Tracker Issue Bug 72796:Provide Tag-based Generation of Excel files (while keeping existing excel functions)
}
The thing to keep in mind with cfexcel is that a primary use case will be generating reports. Using functions for this kind of layout activity can be pretty awkward. There are some nice tools for queries in the functions and tag but very very rarely is a raw query suitable.
I would go further than Adam