displaying top 100 results
Tracker Comment Comment on QueryMap breaks Query-of-Query by Aaron N.
Comment on QueryMap breaks Query-of-Query by Aaron N.
Tracker Issue QueryMap breaks Query-of-Query
QueryMap breaks Query-of-Query
Comment on Map|reduce|sort methods on query objects by Immanuel N.
Tracker Comment Comment on [ANeff] Bug for: ordered struct exception in query.map() callback by CFwatson U.
Comment on [ANeff] Bug for: ordered struct exception in query.map() callback by CFwatson 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.
Map, Reduce, and Filter functions in a query object in ColdFusion
Tracker Comment Comment on queryExecute - Add Map function by External U.
Comment on queryExecute - Add Map function by External U.
Tracker Issue Map|reduce|sort methods on query objects
Map|reduce|sort methods on query objects
Tracker Comment Comment on queryExecute - Add Map function by External U.
Comment on queryExecute - Add Map function 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 queryExecute - Add Map function by Vamseekrishna N.
Comment on queryExecute - Add Map function by Vamseekrishna N.
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.
Tracker Comment Comment on [ANeff] Bug for: ordered struct exception in query.map() callback by CFwatson U.
Comment on [ANeff] Bug for: ordered struct exception in query.map() callback by CFwatson U.
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.
[ANeff] Bug for: ordered struct exception in query.map() callback
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.
be fantastic to bind the CFMap to cfc and its json data.
Further, if we could pass to the cfc the bounds of lat/long of the gmap then we can do some sort of @scroll/@zoom event to trigger a query of new markers based on the new lat/long visibility of the map. Letting people scroll the map and only get
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 queryExecute - Add Map function by External U.
Comment on queryExecute - Add Map function 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 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.
Comment on Map|reduce|sort methods on query objects by External U.
Comment on Map|reduce|sort methods on query objects by External U.
Bug 84119:(Watson Migration Closure)When executing an ORMExecuteQuery() on a mapped cfc (using the datasource attribute to specify a foreign DSN), you shouldn't need to re-specify the datasource (in the HQL query options)
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 External U.
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
Add Support for Map/Reduce/Filter/Each Functions for Query Objects
Tracker Comment Comment on [ANeff] ER for: DeserializeJSON() support for .toJSON()'s serializeQueryByColumns="struct" by Aaron N.
2837411 CF-4198326 Aaron N. To illustrate the ER, here is a wrapper around deserializeJSON() that adds support for .toJSON()'s serializeQueryByColumns='struct':
function udfDeserializeJSON(required string JSONVar, string strictMapping=true, boolean useCustomSerializer=true) output=false hint
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 cfgridcolumn : name parameter is not honored with JS binding in grids. by External U.
2610292 CF-3712885 External U. I've verified this is fixed in CF11 Update 3. Query columns are correctly mapped to their associated grid column when using bind="javascript:.."
Thanks!,
-Aaron
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
Tracker Issue make queries implement an array interface
.slice(): copies rows from within a query.
Query.len(): I'd put this in anyhow, even if one can use recordCount: it's such a ubiquitous function for collections.
Query.filter(): removes rows from the query based on the filter rules.
Query.map(): should already have been implemented.
Query.new(): already got it
Tracker Comment Comment on [ANeff] Bug for: ordered struct exception in query.map() callback by CFwatson U.
Comment on [ANeff] Bug for: ordered struct exception in query.map() callback by CFwatson U.
2608693 CF-4022420 External U. For the iterator methods, the query object should be treated like an array of structs, i.e: [{id:1,name="bob"},{id:2,name="jill"}].
I would also suggest adding a "returnType" argument to the map function so that the query can be iterated and transformed, then return
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.
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 Support plain-named query param types by Rupesh K.
Comment on Support plain-named query param types by Rupesh K.
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 Issue queryExecute - Add Map function
queryExecute - Add Map function
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
2608475 CF-4085682 Language Luis Majano Enhance cfquery or anything that returns queries to return array of structs Hibernate has a feature that returns array of maps instead of array of objects. Returning array of maps is consistently faster than even query objects. I would like to propose
2609052 CF-3941304 External U. I do not accept that response, Awdhesh. "It's hard" is not a valid excuse for doing something that will make the language better.
Here, let me do part of your job for you: You write a KeyExists member function on your query class that converts the row to a map
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.
Portal Topic QueryExecute named parameter gotcha!
machine, but doesn’t work on our QA installation. When using named parameters, ColdFusion can map to the shorting named parameter, ie, if you have both “col1” and “col10” as named parameters, when “col10” gets replaced, it will match “col1” instead. An […]
The post QueryExecute named parameter gotcha
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 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
Tracker Comment Comment on [ANeff] Bug for: ordered struct exception in query.map() callback by CFwatson U.
Comment on [ANeff] Bug for: ordered struct exception in query.map() callback by CFwatson U.
Comment on Query data type should support keyExists member function by Awdhesh K.
dropcreate=true}, the generated tables have the columns in no predictable order if the entity extends a mappedSuperclass. While this doesn't affect the application, per se, it does lead to hard-to-understand tables and requires extra work to get appropriate resultsets when running queries directly
2608923 CF-3963346 External U. Oh, and to clarify, the generated query should be something like this:
select
bars0_.BarID
from
Bars bars0_
where
bars0_.FooID=? and bars0_.YearID=?
2613588 CF-3213501 Piyush K. Seanpford,
closing this since I am not able to observe the issue.
but I am still open to your inputs on the queries in my previous note.
Comment on EntityToQuery Unknown Data Type for Bit Fields by External U.
Tracker Issue ColdFusion 11 - more Debug API features
code base we inherited, there isn't an UML or documentation anywhere. There are thousands of stored proces. We'd like to be able to log/record all the SP's and queries called on each page (URL) thus helping to generate a mapping of things.
I think more features in the Debug API would allow for this
Tracker Comment Comment on [ANeff] Bug for: QoQ incorrect casting by External U.
2673267 CF-4138764 External U. Hi Nimit,
Regarding your comment on CF-4121934:
--------------------------------------------
The recommended Java mapping for the JDBC BIT type is as a Java boolean.
The current behavior is ideally right but we are converting BIT to Integer while dumping a query
". When false, it converts certain string patterns to CF query objects. It could be enhanced to also convert ISO8601 string patterns to CF DateTime objects.
Since both of those solutions would break backward-compat, this ER is for: THIS.serialization.preserveDateTime.
Thanks!,
-Aaron
Tracker Issue Bug 75114:(Watson Migration Closure)The Java classes and interfaces implementing the CF core types should be documented
.lang.String
Struct -> java.util.Map
Array -> java.util.List
It would be nice if the Image and Query types were documented too, but I know half the methods on the Query/java.sql.ResultSet don't work, and the Image is CF specific, so I'm not worried about them so much.
Method:
Result
).
Method:
index.cfm---------SELECT artName FROM artQuery Application.cfc---------------Art.cfc-------
Result:
Query Of Queries runtime error.Unsupported SQL type java.sql.Types.UNKNOWN.coldfusion.sql.imq.ImqUnsupportedSQLTypeException: Query Of Queries runtime error.at coldfusion.sql.imq.rttExpr.SqlToJavaMapping
Portal Comment Comment on CF Camp 2018: Madness in Munich Part Four- ORM-Love it or Hate it? by James Mohler
James Mohler I have a love hate relationship with ORM. When I first saw it I thought of just a .Net technology. Then I though of all the SQL queries that I could (and did) write that did not map into ORM.
But after a second look... I still didn't like it.
But I have to admit it grew on me as I
PageVariables, checkRequestTimeout, checkSimpleParameter, createImplicitVariable, createInitialValue, GetComponentMetadata, getExtends, getImplements, GetMetadata, getOutput, getPagePath, getQueryParamCount, getResolvedComponentPath, initialize, internalIsBoolean, internalIsNumeric, internalIsNumericDate, invoke, isNotMap
Comment on make queries implement an array interface by External U.
Dump(getApplicationMetadata())`
See the following are missing:
cache.querySize
cache.useInternalQueryCache
chartStyleDirectory
customTagPaths
datasource
datasources
debuggingIPAddresses
enableRobustException
googleMapKey
javaSettings
javaSettings.loadColdFusionClassPath
javasettings.loadPaths
javasettings
Tracker Issue Bug 85843:When you are manually doing a cfquery with the type of HQL, the cfqueryparam makes your hql case sensitve
of our base properties for the table. Class B is the Entity that we are referencing and it has no properties in it. When we call the DAO to execute the query with a cfqueryparam in the where clause, it makes the query case sensitive and has to match the class b exactly, which it doesn't because it
are converting BIT to Integer while dumping a query to maintain backward compatibility.
We can do the same for QoQ as well but that would be a major change of behavior and is risky in a hot fix.
Aaron, I have logged a separate bug #CF-4138764 to track the first issue and targeted it to next major Cold
Tracker Comment Comment on The CacheManager has been shut down. It can no longer be used. by External U.
DSN with cityId and cityName columns
- a Listings table in testDSN with a modStamp column
Place files into wwwroot or web mapped directory
Edit files to match your db
Start server
Request cfcachetest/query.cfm
Wait 2 minutes
Request cfcachetest/query.cfm - Results in "The CacheManager has been shut down
Tracker Issue Bug 85248:There are many times when I need to use HQL or other statements and use filters
the "Englinsh" record and use it.However, what I really want at the end of the day is an HQL query (hopefully inside cfquery tag ) where I can say Pre fetch language and filter by englinsh.I can use the where on the mapping because the lnaguage is a dynamic property.I could create a static mapping for each
Portal Comment Comment on Alternatives to Query of Query by Charlie Arehart
Comment on Alternatives to Query of Query by Charlie Arehart
Tracker Issue Source not found, exception in Eclipse .log
.adobe.rds.client.eclipse.debugger.core.launching.CFMLSourceLookupParticipant.getSourceName(CFMLSourceLookupParticipant.java:114)
at org.eclipse.debug.core.sourcelookup.AbstractSourceLookupParticipant.findSourceElements(AbstractSourceLookupParticipant.java:57)
at org.eclipse.debug.core.sourcelookup.AbstractSourceLookupDirector$SourceLookupQuery.run(AbstractSourceLookupDirector.java:139)
at org
Tracker Issue Bug 77227:When a pdf page contains tables, cfpdf extract text not extracting text properly
any virtual - to - physical mapping.SCRIPT_NAME Virtual path to the script that is executing ; used for self - referencing URLs.QUERY_STRING Query information that follows the ? in the URL that referenced this script.REMOTE_HOST Hostname making the request . If the server does not have
Tracker Issue ORM Collection Mapping Multiple Foreign Keys
=false;
property name='bars' elementColumn='BarID' table='Bars' fkColumn='FooID,YearID' fieldType='collection';
}
Actual Result: [Macromedia][SQLServer JDBC Driver][SQLServer]An expression of non-boolean type specified in a context where a condition is expected, near ','.
ORM Generated Query:
2015-04-01 09
Tracker Issue CFQUERY Returning Incorrect Data
some time - but we've run into some issues ever since upgrading from CF9 to CF10 this summer. Specifically, when a database call is made from within a function, we're having sporadic issues with the database call returning incorrect data when the only parameter for the query is a UUID string that
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
Portal Comment Comment on CF2018 – Clear folder specific template cache not working by Charlie Arehart
–though of course the versions of that have changed since CF9. And as of CF2018, you an also now point to different caching engines. But again I don’t think the CF template cache follows that choice. That’s more about things like query caching, page content caching, object caching, etc.
Tracker Issue DB2 9.7 FP9 Insert Query autogenerated keys retrieval fails with “Element 1 is undefined in RDS” error
DB2 9.7 FP9 Insert Query autogenerated keys retrieval fails with “Element 1 is undefined in RDS” error
.createStatement();
resultSet = statement.executeQuery("SELECT * FROM authors");
while ( resultSet.next() ) {
author = resultSet.getString("firstname") & " " & resultSet.getString("lastname");
writeoutput(author & "");
}
--->
ram:///a/b/ is registered in the Administrator --->
2) Create
)
at coldfusion.tagext.search.IndexTag.doQueryUpdate(IndexTag.java:778)
at coldfusion.tagext.search.IndexTag.doStartTag(IndexTag.java:351)
Expected Result:
Template runs without exception and CFINDEX updates the collection.
Any Workarounds:
None tried. Considering uninstalling update and/or adding memory.