RE: cfmodule and query of queries
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. -Original Message- From: Thane Sherrington [mailto:th...@computerconnectionltd.com] Sent: Tuesday, February 09, 2010 7:57 AM To: cf-talk Subject: 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 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330490 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfmodule and query of queries
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: 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 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330491 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfmodule and query of queries
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. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330492 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
