search : query map

select a category, or use search below
(searches all categories and all time range)

displaying top 100 results

QueryMap breaks Query-of-Query
Comment on [ANeff] Bug for: ordered struct exception in query.map() callback by CFwatson 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
Map|reduce|sort methods on query objects
Comment on Map|reduce|sort methods on query objects by External U.
Comment on Map|reduce|sort methods on query objects by External U.
Comment on queryExecute - Add Map function by Vamseekrishna N.
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 Suchika S.
Comment on Map|reduce|sort methods on query objects 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.
Comment on Please add more built-in closure functions: Array/Struct/List/QueryMap, Array/Struct/List/QueryReduce by External U.
Comment on [ANeff] Bug for: ordered struct exception in query.map() callback by CFwatson U.
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
Comment on Please add more built-in closure functions: Array/Struct/List/QueryMap, Array/Struct/List/QueryReduce 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.
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)
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.
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
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
Comment on Add Support for Map/Reduce/Filter/Each Functions for Query Objects 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
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
.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
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
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 Add Support for Map/Reduce/Filter/Each Functions for Query Objects by External U.
Comment on Iterator methods on query objects have not been implemented by Awdhesh K.
queryExecute - Add Map function
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
Comment on Add Support for Map/Reduce/Filter/Each Functions for Query Objects by External U.
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
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
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
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.
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
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
.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
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
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
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
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
Comment on Alternatives to Query of Query by Charlie Arehart
.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
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
=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
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
} 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
–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.

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.