ColdFusion · Database exception
What does Query Of Queries Table Not Found In Memory mean in ColdFusion?
A Query of Queries (dbtype="query") can't locate the source query it's supposed to operate on — usually because dbtype="query" was left off, so ColdFusion tries to resolve the name against a real database instead, or the referenced query variable isn't in scope where the QoQ executes, a common trap with script-based queries called from inside functions.
A Query of Queries (dbtype="query") can't locate the source query it's supposed to operate on — usually because dbtype="query" was left off, so ColdFusion tries to resolve the name against a real database instead, or the referenced query variable isn't in scope where the QoQ executes, a common trap with script-based queries called from inside functions.
Always set dbtype="query" explicitly on Query of Queries calls, and make sure the source query variable is accessible in the same scope the QoQ runs in rather than assuming CFScript query objects behave exactly like tag-based ones.