cfmodule and query of queries

Hi all,   This is probably a stupid question, but my simple mind can't figure it out.  I'm trying to do the following: 1)Have a cfmodule that does a large query. 2)Have a series of cfmodules that do a query of query on the large query 3)Have a script that calls the cfmodules But I can't figure out how to pass the query from one module to another.  I can do it if I use cfinclude, of course, since all the variables are accessible, but when I try to do it from cfmodule to cfmodule, the query of query modules can't access the large query because it's local to the first cfmodule. Is there away around this? T

Set your query as caller.queryName is one way there are others. You should be using a CFC for this and returning the query probably. Hi all,   This is probably a stupid question, but my simple mind can't figure it out.  I'm trying to do the following: 1)Have a cfmodule that does a large query. 2)Have a series of cfmodules that do a query of query on the large query 3)Have a script that calls the cfmodules But I can't figure out how to pass the query from one module to another.  I can do it if I use cfinclude, of course, since all the variables are accessible, but when I try to do it from cfmodule to cfmodule, the query of query modules can't access the large query because it's local to the first cfmodule. Is there away around this? T

You should really be doing this in a CFC.  They're built for stuff like this. Thanks, Eric Cobb http://www.cfgears.com ColdFusion - the most profitable "dead" language I've ever worked with. Thane Sherrington wrote: ----- Excess quoted text cut - see Original Post for more -----

>>But I can't figure out how to pass the query from one module to another. You can also set your query in the request scope, ie : request.MyQuery The request scope is visible in any module and sub modules.