Stack Overflow
Stack Overflow

Questions tagged [qoq]

ColdFusion Query of Queries (QoQ) is used to re-query the result of one or more original queries.

ColdFusion Query of Queries (QoQ) let you query the results of an existing database query. A QoQ uses the <cfquery> and is very similar to querying against a database. Example:

<cfquery name="this.qryReportDefGroup" dbtype="query">
    SELECT  SourceTypeID, cyclelocked
    FROM    request.stData.qryReportDefGroup
</cfquery>

The FROM statement in this case references a variable that is a part of a structure. The SQL inside of a QoQ is specific to ColdFusion. The results of a QoQ can be used in yet another QoQ.

You can also query a non-database query object, for example, the results of a cfftp directory listing. src: http://www.quackit.com/coldfusion/tutorial/coldfusion_query_of_queries.cfm

83 questions
3
votes
1 answer

Two extra columns with using HAVING in QoQ Coldfusion

When I use HAVING in my QoQ coldfusion, the query returned will have two extra column: "Column_7" and "Column_8" The original resultat And the resultat with two extra columns Here is my code var qEffectifTemp = queryExecute(" SELECT…
Li xiaoyu
  • 53
  • 5
3
votes
2 answers

How to test for null/empty string in Coldfusion query of query?

I've been looking online for a solution, but none's come up. I have a column in a coldfusion query, "date_hired". If I do a cfdump of the query, it shows as a date if its a date or as [empty string] if not. There are 8 records in the query; and some…
Cmaso
  • 1,095
  • 1
  • 10
  • 23
3
votes
0 answers

ColdFusion Performance Implication of Query of Queries

This is an extreme longshot, but once in a while there is an engineer on here that knows what's going on under the hood. First, I know that you can almost always rewrite some code to avoid QoQ for much better performance. However, what I'm trying…
J.T.
  • 2,606
  • 15
  • 31
3
votes
2 answers

ColdFusion Query-of-Queries Wildcard LIKE condition not working with single quotes?

I have a query-of-queries that performs a LIKE condition on a variable string: When the variable contains a single word that includes a single quote, some results are returned, but not all:
Eric Belair
  • 10,574
  • 13
  • 75
  • 116
3
votes
1 answer

Query of Queries syntax error

I have to get records from a Query using Query of Queries in my F/W1 application. Im running it in coldfusion 10. My Query is as follows, Select * from qryFormfields where language =…
Marikkani Chelladurai
  • 1,430
  • 1
  • 13
  • 23
3
votes
2 answers

Query on free text field

EDIT: Actually, I run MSSQL query, let say the result is: ID pagename 1 1 2 01 3 01, 15 Then, I run another command URL and got the result as xml data, let say the result (in simple form) is: 4 01, 01 Aaa, 15 5 02 6 03 7 100 8 …
Nurkartiko
  • 183
  • 2
  • 10
2
votes
7 answers

Query of queries outside ColdFusion

My experience of using Adobe ColdFusion, even if still somewhat limited, was absolutely joyful and pleasant. Of all good things I could say about ColdFusion, one feature completely blew me off my feet. It might be neither very effective, or useful…
shylent
  • 10,076
  • 6
  • 38
  • 55
2
votes
2 answers

Is it possible to cache a ColdFusion Query of Query

I've got query that is returning all translations for a site. It does this by getting all translations that are in the users desired language, then the remaining that are in the site default language, then any other strings that have not been…
nosilleg
  • 2,143
  • 1
  • 22
  • 36
2
votes
1 answer

How to use Query of Queries as subquery (Coldfusion)

I want to use a query of queries as a subquery but i get a syntax error: Encountered "(. Here is my query (qHistoryData is my query object): SELECT * FROM ( SELECT t2.*, ROW_NUMBER()…
FlowLess10
  • 133
  • 10
2
votes
1 answer

Can you filter rows in a Query of Queries using a property value of a struct column value?

If an object, such as an Array or Struct is used as the column value of a row in a CF query object. Can properties of that object be used in the WHERE clause of a query of queries to limit the result set? Given:
C.J. Scupski
  • 33
  • 3
2
votes
1 answer

How to prevent Query of Queries returning case sensitive results from CFC in Coldfusion

I have an issue where I'm joining two record sets from two different datasources using Ben Nadel's QueryAppend.cfc. The data I get back is correct but the ordering of the data is not expected. The combined result set is being sorted like so with all…
cflingo
  • 47
  • 7
2
votes
3 answers

CASE in Query of a Query

In ColdFusion, after having queried an MSSQL Database and added a couple of rows with the QueryAddRow function, I need to reorder the query by doing a query of a query. The order that I need requires that I use the CASE expression within the ORDER…
SindreKjr
  • 249
  • 2
  • 17
2
votes
2 answers

cfloop and query of queries

I have a scenario like below on a page. I have a query being returned from a cfc all_data which has columns, section, state, data. Now the page design looks something like below. section1 section2 section3 section4 -> select one section to select…
user747291
  • 821
  • 3
  • 20
  • 43
2
votes
1 answer

Coldfusion Query of Queries with Empty Strings

The query I start out with has 40,000 lines of empty rows, which stems from a problem with the original spreadsheet from which it was taken. Using CF16 server I would like to do a Query of Queries on a variably named 'key column'. In my query: var…
Matt Wilde
  • 271
  • 2
  • 18
2
votes
1 answer

Distinct QoQ automatically applying order by

I am using CFSpreadsheet to read a .xlsx file. The file has about 3000 duplicates which I can safely ignore so I thought I'd do a select distinct QoQ but once I do this, the results are ordered as if order by col_1, col_2 was added to the query…
genericHCU
  • 4,394
  • 2
  • 22
  • 34
1
2
3 4 5 6