Skip to main content
R
r_yogarajah
Participant
May 4, 2012
Answered

Perform SQL search in QueryObject

  • May 4, 2012
  • 1 reply
  • 391 views

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

This topic has been closed for replies.
Correct answer r_yogarajah

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>

1 reply

R
r_yogarajahAuthorCorrect answer
Participant
May 10, 2012

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>
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices