displaying top 100 results
Tracker Issue query of query WHERE filter no longer disregards filler spaces in fixed with data fields
query of query WHERE filter no longer disregards filler spaces in fixed with data fields
Tracker Comment Comment on query of query WHERE filter no longer disregards filler spaces in fixed with data fields by External U.
Comment on query of query WHERE filter no longer disregards filler spaces in fixed with data fields by External U.
Tracker Comment Comment on query of query WHERE filter no longer disregards filler spaces in fixed with data fields by Nimit S.
Comment on query of query WHERE filter no longer disregards filler spaces in fixed with data fields by Nimit S.
Tracker Comment Comment on query of query WHERE filter no longer disregards filler spaces in fixed with data fields by Nimit S.
Comment on query of query WHERE filter no longer disregards filler spaces in fixed with data fields by Nimit S.
Tracker Comment Comment on query of query WHERE filter no longer disregards filler spaces in fixed with data fields by External U.
Comment on query of query WHERE filter no longer disregards filler spaces in fixed with data fields by External U.
Tracker Comment Comment on query of query WHERE filter no longer disregards filler spaces in fixed with data fields by Himavanth R.
Comment on query of query WHERE filter no longer disregards filler spaces in fixed with data fields by Himavanth R.
Tracker Comment Comment on query of query WHERE filter no longer disregards filler spaces in fixed with data fields by External U.
Comment on query of query WHERE filter no longer disregards filler spaces in fixed with data fields by External U.
Tracker Comment Comment on QueryFilter mutates the original query by Carl V.
Comment on QueryFilter mutates the original query by Carl V.
Tracker Comment Comment on QueryFilter mutates the original query by Chris D.
Comment on QueryFilter mutates the original query by Chris D.
Tracker Issue Query.filter() returns an *array* not a query
Query.filter() returns an *array* not a query
Comment on Query.filter() returns an *array* not a query by CFwatson U.
Comment on Query.filter() returns an *array* not a query by External U.
Tracker Comment Comment on QueryFilter mutates the original query by Peter F.
Comment on QueryFilter mutates the original query by Peter F.
Tracker Comment Comment on QueryFilter mutates the original query by Aaron N.
Comment on QueryFilter mutates the original query by Aaron N.
Tracker Comment Comment on QueryFilter mutates the original query by Jim P.
Comment on QueryFilter mutates the original query by Jim P.
Tracker Comment Comment on QueryFilter mutates the original query by Jon L.
Comment on QueryFilter mutates the original query by Jon L.
Tracker Comment Comment on QueryFilter mutates the original query by Kama S.
Comment on QueryFilter mutates the original query by Kama S.
Tracker Comment Comment on QueryFilter mutates the original query by Jim P.
Comment on QueryFilter mutates the original query by Jim P.
Tracker Comment Comment on QueryFilter mutates the original query by Steve J.
Comment on QueryFilter mutates the original query by Steve J.
Tracker Comment Comment on QueryFilter mutates the original query by Jon L.
Comment on QueryFilter mutates the original query by Jon L.
Tracker Comment Comment on QueryFilter mutates the original query by John W.
Comment on QueryFilter mutates the original query by John W.
Tracker Comment Comment on QueryFilter does not remove rows as expected when consecutive target rows exist by John W.
Comment on QueryFilter does not remove rows as expected when consecutive target rows exist by John W.
Tracker Issue cfdirectory maxrows filter for action="list"
to have all files under a single directory.
Even with the filter "1098013_1277097_0_0_0_0_1620px_1040px_*.pdf", it can return hundreds (potentially even thousands of rows).
While I can use a query of queries to retrieve the latest saved file, it would make more sense to have a maxrows parameter
Comment on queryFilter passes incorrect rownumber as 2nd argument by Aaron N.
Comment on Query.filter() returns an *array* not a query by CFwatson U.
Comment on Query.filter() returns an *array* not a query by External U.
Tracker Comment Comment on QueryFilter mutates the original query by John W.
Comment on QueryFilter mutates the original query by John W.
Tracker Comment Comment on QueryFilter mutates the original query by Tony J.
Comment on QueryFilter mutates the original query by Tony J.
Tracker Comment Comment on QueryFilter mutates the original query by Tony J.
Comment on QueryFilter mutates the original query by Tony J.
Comment on QueryFilter mutates the original query by Sebastian H.
Tracker Issue QueryFilter mutates the original query
QueryFilter mutates the original query
Tracker Comment Comment on QueryFilter does not remove rows as expected when consecutive target rows exist by Vamseekrishna N.
Comment on QueryFilter does not remove rows as expected when consecutive target rows exist by Vamseekrishna N.
Tracker Comment Comment on QueryFilter does not remove rows as expected when consecutive target rows exist by Vamseekrishna N.
Comment on QueryFilter does not remove rows as expected when consecutive target rows exist by Vamseekrishna N.
Tracker Comment Comment on QueryFilter does not remove rows as expected when consecutive target rows exist by Adam C.
Comment on QueryFilter does not remove rows as expected when consecutive target rows exist by Adam C.
Tracker Comment Comment on QueryFilter does not remove rows as expected when consecutive target rows exist by Adam C.
Comment on QueryFilter does not remove rows as expected when consecutive target rows exist by Adam C.
Tracker Comment Comment on QueryFilter does not remove rows as expected when consecutive target rows exist by Aaron N.
Comment on QueryFilter does not remove rows as expected when consecutive target rows exist by Aaron N.
Comment on queryFilter passes incorrect rownumber as 2nd argument by John W.
Tracker Comment Comment on QueryFilter mutates the original query by John W.
Comment on QueryFilter mutates the original query by John W.
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.
Map, Reduce, and Filter functions in a query object in ColdFusion
2609257 CF-3863993 File Management Peter Boughton DirectoryList sometimes errors on empty string for filter when using UNC paths This code was erroring:
var DiskQuery = DirectoryList
( Arguments.RootDir&Arguments.Location
, false
, "query"
, FilterGlob
, Arguments.Sort
, 'file
QueryFilter does not remove rows as expected when consecutive target rows exist
error: "Property true not present in the entity."
Expected Result:
For it to work
Any Workarounds:
Use ormExecuteQuery() instead.
PS: There are two more combinations I found to not work (not even compile):
entityLoad( entityName, id, order, options )
entityLoad( entityName, id, unique, options )
2673325 CF-4126735 External U. Adobe,
Will cfdirectory's maxrows attribute behave the same as cfquery's maxrows attribute? Meaning, Java will still list *all* files to CF. And maxrows only limits the number of rows in the query? So Java is still doing the same amount of work? Where
Tracker Issue Bug 84596:When I put in a dodgy filter string
:Connection to ldap server failed.Detail [empty string]Message Connection to LDAP server failed.StackTrace coldfusion.tagext.net.LdapTag$UnknownHostException: Connection to LDAP server failed. at coldfusion.tagext.net.LdapTag.do_ActionQuery(LdapTag.java:892) at coldfusion
Tracker Issue cfgrid: query bind is failing
cfgrid: query bind is failing
Tracker Issue Improve joining in query of query
2609297 CF-3861312 Database : Query-of-Query(IMQ) Adam Cameron Improve joining in query of query CFML's QoQ is very limited in how it can join queries:
* only two queries
* only old-school filter joins (eg: from q1, q2 where q1.pk=q2.fk)
* no outer joins
This implementation is lovely for a proof
Tracker Issue queryFilter passes incorrect rownumber as 2nd argument
queryFilter passes incorrect rownumber as 2nd argument
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 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 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 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 Comment Comment on QueryFilter does not remove rows as expected when consecutive target rows exist by Tim B.
Comment on QueryFilter does not remove rows as expected when consecutive target rows exist by Tim B.
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 DirectoryList sometimes errors on empty string for filter when using UNC paths by External U.
it as ticketCF-3863993
2) Create C:\ticketCF-3863993\myfile.txt
3) Run the following code:
//These fail
writeDump(directoryExists("file://localhost/C:/ticketCF-3863993"));//Returns NO
q = directoryList("file://localhost/ticketCF-3863993", false, "query", "");//Throws exception: Could not find files
Tracker Comment Comment on Bug 83517:(Watson Migration Closure)in the new cf9 cfscript query cfcyou must have a space after named parameters by External U.
2598091 CF-3041750 External U. I found the same problem the hard way.
I was using it on a query of query to filter data returnd from directoryList.
qof.setSql("
SELECT * FROM sourceDirectory
WHERE
DIRECTORY = :DIRECTORY
AND NAME = :NAME
AND DATELASTMODIFIED = :DATELASTMODIFIED
");
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
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 Query-Of-Query syntax error when filtering by a string with two dashes by Yogesh P.
Comment on Query-Of-Query syntax error when filtering by a string with two dashes by Yogesh P.
Tracker Issue Query of queries defect when filtering on a varchar field that happens to be in a similar format to YYYY-MM-DD.
Query of queries defect when filtering on a varchar field that happens to be in a similar format to YYYY-MM-DD.
Tracker Issue Bug 72679:While indexing about 10,000 records from a query the indexing process stopped without error
Bug 72679:While indexing about 10,000 records from a query the indexing process stopped without error
Add Support for Map/Reduce/Filter/Each Functions for Query Objects
Tracker Issue Unable to run query inside Dynamic Proxy
Unable to run query inside Dynamic Proxy
Tracker Comment Comment on Query of queries defect when filtering on a varchar field that happens to be in a similar format to YYYY-MM-DD. by External U.
Comment on Query of queries defect when filtering on a varchar field that happens to be in a similar format to YYYY-MM-DD. 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.
Bug 81646:Any time I try to use preserveSingleQuotes() inside a CFQUERYPARAM with list="yes", the query doesn't return any values at all and throws an error saying that the query name doesn't exist
Query-Of-Query syntax error when filtering by a string with two dashes
Tracker Comment Comment on Query-Of-Query syntax error when filtering by a string with two dashes by Yogesh P.
Comment on Query-Of-Query syntax error when filtering by a string with two dashes by Yogesh P.
Tracker Issue Bug 81261:Queries created using EntityToQuery() throw errors when trying to use Query of Queries
Bug 81261:Queries created using EntityToQuery() throw errors when trying to use Query of Queries
to support this feature. Can we add it?
Method:
Result:
Please add support for previousCriteria with solr (cfsearch). If I'm correct Lucene/solr supports this functionality using QueryFilter combined with BooleanQuery.
----------------------------- Additional Watson Details
Bug 82229:Using a tab instead of a space after "FROM" or "SELECT" in the HQL passed to ormExecuteQuery() causes the error "Not supported for select queries" to be thrown
Comment on Map|reduce|sort methods on query objects by External U.
Tracker Issue Bug 76111:Mysql driver 5
.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3438) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477) at com
:
The database gets updated as expected, but an exception is thrown, as below -
java.lang.NullPointerException at coldfusion.sql.CFNoResultSetTable.(CFNoResultSetTable.java:46) at coldfusion.sql.Executive.getRowSet(Executive.java:606) at coldfusion.sql.Executive.executeQuery(Executive.java:1383) at coldfusion.sql.Executive.executeQuery
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 Comment Comment on Clear Query Cache breaks by External U.
Comment on Clear Query Cache breaks by External U.
Bug 82178:With ColdFusion 9 CHF 1 installed, using a column name when using query-of-queries on a query returned from entityToQuery() which has had an extra column added using queryAddColumn() throws the error
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.
Comment on Iterator methods on query objects have not been implemented by Aaron N.
Tracker Issue Sending Ajax Request with JSON throws an exception
)
coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
root cause
java.lang.IllegalArgumentException
coldfusion.filter.FormScope.parseQueryString(FormScope.java:464)
coldfusion.filter.FormScope.parsePostData(FormScope.java:435)
coldfusion.filter.FormScope.fillForm(FormScope.java:385
).If the fetch="join" attribute is taken away (and lazy loading is used in its place), then the entityLoad() call runs as expected.The incorrect behavior is also exhibited when running ORMExecuteQuery() when LEFT JOIN FETCH'ing the one-to-many relationship. I included both examples in my sample code. Be sure
Tracker Comment Comment on Sporadic server errors: Cannot create a session after the response has been committed by Terry F.
is generated upon trying to handle this bug. Or something?
This exception precedes the exception above:
"Error","ajp-nio-8016-exec-25","07/24/17","04:03:12","",""
java.lang.IllegalArgumentException
at coldfusion.filter.FormScope.parseQueryString(FormScope.java:582)
at coldfusion.filter
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 Clear Query Cache breaks by External U.
Comment on Clear Query Cache breaks by External U.
)
at coldfusion.monitor.es.Configuration.updateDBList(Configuration.java:237)
at coldfusion.monitor.event.RequestMonitorEventProcessor.onQueryStart(RequestMonitorEventProcessor.java:890)
at coldfusion.sql.SqlImpl.recordQueryMetrics(SqlImpl.java:519)
at coldfusion
- type Exception reportmessage
description The server encountered an internal error () that prevented it from fulf
illing this request.exception javax.servlet.ServletException: ROOT CAUSE:
java.lang.IllegalArgumentException
at coldfusion.filter.FormScope.parseQueryString(FormScope.java:373
:
Application.cfc
---
component {
this.javaSettings = {
LoadPaths = ["./lib"]
, loadColdFusionClassPath = true
, reloadOnChange= true
, watchInterval = 100
, watchExtensions = "jar"
};
}
twitter.cfm
---
query=CreateObject("java", "twitter4j.Query").init(JavaCast("string", "from
Tracker Comment Comment on Between CF 11,0,04,293328 and 11,0,10,300066, DataDirect Oracle JDBC driver updated and now causing closed connections. by Jonas M.
.2.0.4:
Success every time
Actual result in CF2016 (2016.0.03.301771) with Oracle 11.2.0.4 or Oracle 12.1.0.2 (with latest bundle patches):
Exception every time:
Error Executing Database Query.
[Macromedia][Oracle JDBC Driver]Object has been closed.
The error occurred in C
Tracker Issue Filter NOT changing grid resultset
2608619 CF-4048126 AJAX : UI Components David Jacobson Filter NOT changing grid resultset Problem Description: When entering a value in a search field and filtering the grid data, the value of the field doesn't get passed to the cfc query for the grid as previous before 4.x upgrade.
Steps
Tracker Issue Bug 76071:[JFERNANDES] Unable to paginate records with entityLoad when using MSSQL server
)
at macromedia.jdbc.base.BaseResultSet.validateScrollable(Unknown Source)
at macromedia.jdbc.base.BaseResultSet.absolute(Unknown Source)
at org.hibernate.loader.Loader.advance(Loader.java:1502)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1813)
at org.hibernate.loader.Loader.doQuery
Tracker Issue <Regression> CacheRemove throws an exception when one or more queries do not have cacheId attribute
Tracker Issue Bug 79062:(Watson Migration Closure)There is no reason why cfspreadsheet should not be able to use the VFS for reading
:
Result:
java.io.FileNotFoundException: ram:\authorData.xlsx (The filename, directory name, or volume label syntax is incorrect)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.(FileInputStream.java:106)
at java.io.FileInputStream.(FileInputStream.java:66)
at coldfusion.tagext.lang.SpreadSheetTag.readExcelToQuery
Tracker Comment Comment on JavaSettings.LoadPaths and ObjectLoad do not seem to work together by Tyler C.
3541175 CF-4199826 Tyler C. The same issue exists when using straight Java
byteOutStream = createObject("java", "java.io.ByteArrayOutputStream").init();
objOutStream = createObject("java", "java.io.ObjectOutputStream").init(byteOutStream);
objOutStream.WriteObject(query);
serialized = byte
Bug 74737:I was doing some simulations of migration, and to my surprise a system that runs on CF8 did not behave well in the centaur, received Query Of Queries runtime error, then put an abort before I made a m
Tracker Comment Comment on Bizzare behavior in cflayout due to change in default setting for action in cfform by Adobe D.
2614735 CF-3080158 Adobe D. This is breaking in the scenarios in which the query string contains percentage encoding characters which are not valid.
POC :
test.cfm
try access the page using url http:///test.cfm?myval=%^g
Error :
There was an error while encoding.
For more details check
Tracker Issue cfdump, top, and arrays
2610000 CF-3738230 Debugging Raymond Camden cfdump, top, and arrays When you cfdump a query and use top=X, the dump nicely tells you it filtered:
[Filtered - Top 1 of 2 rows]
When you do the same w/ an array, it does not, and should.
----------------------------- Additional Watson Details
Tracker Issue Bug 74091:If you have a persistent object name object
Address 127.0.0.1
Referrer http://localhost:8500/bug/
Date/Time 15-Dec-08 01:32 PM
Stack Trace
at cfa2ecfm2079463007.runPage(C:\dev\ColdFusion\cf_main\cfusion\wwwroot\bug\a.cfm:1)
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: object near line 1, column 6 [from object]
at org.hibernate.hql.ast.QuerySyntaxException.convert(Query