Output to a Query

[TommyMTL]

Is it possible to output a query to a new dynamic query. The idea is to manipulate data from an original query then to cach that information to output to an XLS file. For now, I am dynamicaly building a table with the original query and make a query on that new table that contain the information I need in the way I need it.

many thaks

[iKnowKungFoo]

Read about query of queries.

[TommyMTL]

Hi CF_menace, thanks for your reply, I might not explained myself clearly, but I don't think this is what i am looking for.

On my original QUERY, I have to perform a subset query at 3 level to replace tremendous amount or information from 4 different query and then build a final result to a query - WITH THE CODE EXEMPLE I BUID A TABLE TO A DATABASE. So Query of Query will definitely, and It does, do the fist step where I can output proper format between <cfoutput> tags but I need to output to a query or somethins that I can reuse on a final query.

thanks

[Dan_Bracuk]

There are query functions that enable you to change query results after you run you run the query. They all start with the word Query. Details are in the cfml reference manual. If you don't have one, the internet does.