Perform SQL search in QueryObject

[r_yogarajah]

Hi,

I've parsed a very complicated XML into several QueryObjects - more or less got now 3 "tables".

Now i would like to use these three tables and perform a SQL search. something like

Select * From tblMenu Where menu_dayId = 2

I have searched and also tried to find a way in the Coldfusionreference, but was not lucky.

Does anyone got a solution how i can achieve this goal?

greets

[r_yogarajah · Accepted solution]

Found an answer: You just have to ask the correct question. QoQ = Query of Queries

<cfset tblMenu = QueryNew("menuId, menu_dayId, menuDesc") />
...
<cfquery dbtype="query" name="tblToday">
            select * from tblMenu
            where menu_dayId = #curWorkDay#
</cfquery>