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
0
votes
0 answers

why sql query of query works locally but not remote?

I'm using a Query of Queries to output list of files in a folder with the filter DateLastModified DESC. It works fine locally, but not on the remote site.
Shalinko
  • 21
  • 1
  • 4
0
votes
1 answer

Inconsistent Q of Q Behaviour

Using ColdFusion Server Enterprise 9,0,1,274733. Has anyone seen this before? The following code executes without error. select event_code, event_name from event
Dan Bracuk
  • 20,699
  • 4
  • 26
  • 43
0
votes
4 answers

Merging a array of queries into a single query

I want to merge an array of queries into one query I have tried this SELECT * FROM arData[k]
James A Mohler
  • 11,060
  • 15
  • 46
  • 72
0
votes
1 answer

Logical comparison of boolean literals in coldfusion query of queries?

How does one compare a boolean column with a boolean literal? The ColdFusion Query of Queries user guide claims to support comparison of boolean literals. Test conditional This conditional tests whether a Boolean expression is True, False, or…
Jared Beck
  • 16,796
  • 9
  • 72
  • 97
0
votes
2 answers

Not getting desired output after executing a QoQ

I'm running the following SQL queries and am not getting a desired output: SELECT count(Timedetail) as Occurances, date_format(Timedetail,'%m-%d-%Y') FROM MyDatabase WHERE EVENTS =…
Tan
  • 1,433
  • 5
  • 27
  • 47
0
votes
2 answers

Coldfusion: SELECT FROM QoQ WHERE X in (SELECT Y FROM QoQ) not working

In CF I am trying to do a QoQ where the rows are in a list of other rows. Basically moving some code from cftags to cfscript (Not important why). In tags we have a main query and we have several nests that do some heavy lifting. I am moving this to…
Leeish
  • 5,203
  • 2
  • 17
  • 45
0
votes
1 answer

ColdFusion query of query strange type cast

SELECT * FROM modelliDelMarchio WHERE marchioid = #ARGUMENTS.marchioid# AND tipologia = #ARGUMENTS.tipo# AND nome = '#ARGUMENTS.nome#' I have an error on the last…
Fabio B.
  • 9,138
  • 25
  • 105
  • 177
-1
votes
1 answer

CFChart producing a 500 Error

I am trying to create a chart with a query of queries, but am receiving a 500 error no matter what I try. I ended up scoping down the cfchart tag as the problem, but couldn't find any syntax errors in it, nor any logical errors.
N. Ziff
  • 13
  • 5
1 2 3 4 5
6