displaying top 100 results
Tracker Issue Alphabetical ordering in query of queries differs from ordering in query from database
Alphabetical ordering in query of queries differs from ordering in query from database
Tracker Issue Alphabetical ordering in query of queries differs from ordering in query from database
Alphabetical ordering in query of queries differs from ordering in query from database
Tracker Issue Alphabetical ordering in query of queries differs from ordering in query from database
Alphabetical ordering in query of queries differs from ordering in query from database
2610677 CF-3687749 Language Adam Cameron Please add some additional functionality to query of queries in upcoming versions This is a recreation of an E/R that was in the old system but never migrated to the new system:
{quote}
Open Enhancement 71968 (Query-of-Query (IMQ))
Submitted By: Hemant
cfquery query of queries count(*) returns nothing when there are 0 rows
Tracker Comment Comment on Alphabetical ordering in query of queries differs from ordering in query from database by Michael C.
Comment on Alphabetical ordering in query of queries differs from ordering in query from database by Michael C.
Tracker Comment Comment on Alphabetical ordering in query of queries differs from ordering in query from database by Nimit S.
Comment on Alphabetical ordering in query of queries differs from ordering in query from database by Nimit S.
Tracker Comment Comment on Alphabetical ordering in query of queries differs from ordering in query from database by Nimit S.
Comment on Alphabetical ordering in query of queries differs from ordering in query from database by Nimit S.
Tracker Comment Comment on Alphabetical ordering in query of queries differs from ordering in query from database by Michael C.
Comment on Alphabetical ordering in query of queries differs from ordering in query from database by Michael C.
Portal Topic Unioning queries using query of query
Unioning queries using query of query
Tracker Comment Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by External U.
Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by External U.
Tracker Comment Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by External U.
Comment on cfquery query of queries count(*) returns nothing when there are 0 rows 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 cfquery query of queries count(*) returns nothing when there are 0 rows by Rupesh K.
Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by Rupesh K.
Tracker Comment Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by External U.
Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by External U.
Tracker Comment Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by External U.
Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by External U.
Tracker Comment Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by External U.
Comment on cfquery query of queries count(*) returns nothing when there are 0 rows 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 cfquery query of queries count(*) returns nothing when there are 0 rows by External U.
Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by External U.
Tracker Comment Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by Rupesh K.
Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by Rupesh K.
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 cfquery query of queries count(*) returns nothing when there are 0 rows by Samuel K.
Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by Samuel K.
Tracker Comment Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by Doug C.
Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by Doug C.
Tracker Comment Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by External U.
Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by External U.
Tracker Comment Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by External U.
Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by External U.
Tracker Comment Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by Aaron N.
Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by Aaron N.
Tracker Comment Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by External U.
Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by External U.
Tracker Comment Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by j a.
Comment on cfquery query of queries count(*) returns nothing when there are 0 rows by j a.
Comment on Unioning queries using query of query by LrdJester
Comment on Bug 83347:(Watson Migration Closure)When a query result contains a string that looks like a date, and you run a query of queries looking for records that match that string, an equal sign will not work by External U.
Bug 83347:(Watson Migration Closure)When a query result contains a string that looks like a date, and you run a query of queries looking for records that match that string, an equal sign will not work
Comment on Bug 83347:(Watson Migration Closure)When a query result contains a string that looks like a date, and you run a query of queries looking for records that match that string, an equal sign will not work by Nimit S.
Comment on Unioning queries using query of query by Norbert Liedert
Portal Topic Alternatives to Query of Query
Alternatives to Query of Query
Portal Comment Comment on Alternatives to Query of Query by aliaspooryorik
Comment on Alternatives to Query of Query by aliaspooryorik
Tracker Issue Add CASE construct to query of query
2609294 CF-3861324 Database : Query-of-Query(IMQ) Adam Cameron Add CASE construct to query of query As per the ANSI standard, eg: http://en.wikipedia.org/wiki/SQL#Conditional_.28CASE.29_expressions
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID
Tracker Issue Query of queries results
Query of queries results
2598005 CF-3041855 Database : Query-of-Query(IMQ) Jorrit Janszen Bug 83749:-(Watson Migration Closure)There is a problem when you do a query of query when you use a queryService query of a queryNew() query Problem:
There is a problem when you do a query of query when you use a queryService query
Comment on Query of queries where in (select ...) not working by External U.
Comment on Query of queries doesn't support subqueries by External U.
Tracker Comment Comment on Add CASE construct to query of query by Aaron N.
Comment on Add CASE construct to query of query by Aaron N.
Tracker Comment Comment on Add CASE construct to query of query by External U.
Comment on Add CASE construct to 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.
Tracker Comment Comment on Improve joining in query of query by External U.
Comment on Improve joining in query of query by External U.
Tracker Comment Comment on Improve joining in query of query by Aaron N.
Comment on Improve joining in query of query by Aaron N.
Tracker Comment Comment on Improve joining in query of query by External U.
Comment on Improve joining in query of query by External U.
Tracker Issue Query of queries doesn't support subqueries
2596683 CF-3928373 Database : Query-of-Query(IMQ) Dorin Moise Query of queries doesn't support subqueries Problem Description: An old problem described here:
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:43227
Steps to Reproduce:
{code:java}
SELECT foo FROM bar
select
ColdFusion Query of Queries (Streamline your Processes)
Tracker Comment Comment on Query of queries results by External U.
Comment on Query of queries results by External U.
Empty queries on Axis 2 comes back as a QueryBean object instead of empty query
Comment on Query of queries doesn't support subqueries by External U.
Comment on Query of queries strips leading/trailing whitespace by Himavanth R.
Tracker Issue Query of queries strips leading/trailing whitespace
Query of queries strips leading/trailing whitespace
Tracker Comment Comment on Add CASE construct to query of query by External U.
Comment on Add CASE construct to query of query by External U.
Tracker Comment Comment on Add CASE construct to query of query by Adam C.
Comment on Add CASE construct to query of query by Adam C.
Tracker Comment Comment on Add CASE construct to query of query by External U.
Comment on Add CASE construct to query of query by External U.
Tracker Comment Comment on Add CASE construct to query of query by External U.
Comment on Add CASE construct to 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.
Tracker Comment Comment on Improve joining in query of query by Adam C.
Comment on Improve joining in query of query by Adam C.
Tracker Comment Comment on Improve joining in query of query by External U.
Comment on Improve joining in query of query by External U.
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 Comment Comment on Enhance cfquery or anything that returns queries to return array of structs by External U.
Comment on Enhance cfquery or anything that returns queries to return array of structs by External U.
Comment on Query of Queries giving the wrong result by External U.
case-insensitive queries.
Many more tips are available here:
query-of-queries/query-of-queries-user-guide.html" rel="nofollow">https://helpx.adobe.com/coldfusion/developing-applications/accessing-and-using-data/using-query-of-queries/query-of-queries-user-guide.html
Tracker Comment Comment on QueryMap breaks Query-of-Query by Aaron N.
Comment on QueryMap breaks Query-of-Query by Aaron N.
Tracker Comment Comment on Query of queries results by External U.
Comment on Query of queries results by External U.
Comment on Query of queries doesn't support subqueries by External U.
Comment on Query of queries doesn't support subqueries by External U.
Comment on Query of queries strips leading/trailing whitespace by External U.
Tracker Comment Comment on Add CASE construct to query of query by External U.
Comment on Add CASE construct to query of query by External U.
Tracker Comment Comment on Add CASE construct to query of query by External U.
Comment on Add CASE construct to query of query by External U.
Tracker Comment Comment on Add CASE construct to query of query by External U.
Comment on Add CASE construct to 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.
Tracker Comment Comment on Improve joining in query of query by External U.
Comment on Improve joining in query of query by External U.
Tracker Comment Comment on Improve joining in query of query by External U.
Comment on Improve joining in query of query by External U.
Tracker Comment Comment on Improve joining in query of query by External U.
Comment on Improve joining in query of query by External U.
Portal Comment Comment on Alternatives to Query of Query by Benjamin Reid
Comment on Alternatives to Query of Query by Benjamin Reid
Tracker Comment Comment on Empty queries on Axis 2 comes back as a QueryBean object instead of empty query by Poonam J.
Comment on Empty queries on Axis 2 comes back as a QueryBean object instead of empty query by Poonam J.
Tracker Comment Comment on Empty queries on Axis 2 comes back as a QueryBean object instead of empty query by External U.
Comment on Empty queries on Axis 2 comes back as a QueryBean object instead of empty query by External U.
Tracker Comment Comment on Empty queries on Axis 2 comes back as a QueryBean object instead of empty query by Poonam J.
Comment on Empty queries on Axis 2 comes back as a QueryBean object instead of empty query by Poonam J.
Tracker Comment Comment on Empty queries on Axis 2 comes back as a QueryBean object instead of empty query by External U.
Comment on Empty queries on Axis 2 comes back as a QueryBean object instead of empty query by External U.
Bug 86199:Add CFML and XML tag literals to cfscript (Enhancement Request)Performing queries and queries of queries in cfscript is quite verbose (compary to using the cfquery tag)
Comment on Query of Queries giving the wrong result by External U.
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
Tracker Comment Comment on CF9 Query of Queries on CF10 Query object only returns the first row by External U.
Comment on CF9 Query of Queries on CF10 Query object only returns the first row by External U.
Comment on Query of Queries giving the wrong result by Himavanth R.
Comment on Query of Queries giving the wrong result by External U.
Comment on Query of Query and SQL statements ending in semicolon by External U.