Hello,
Can somebody help me to combine these two queries into one query.
<cfquery datasource="#DATAS#" name="getMainNav">
SELECT *
FROM navigatie2
WHERE taalid = #taalid# AND
navigatieid1 = #navigatieid1# AND
active = 1
ORDER BY orderID
</cfquery>
<cfif #url.navigatieID2# NEQ ''>
<cfoutput query="getMainNav">
<cfquery datasource="#DATAS#" name="getSubNav">
SELECT *
FROM navigatie3
WHERE navigatieID2 = #url.navigatieID2# AND
taalid = #taalid# AND
active = 1
ORDER BY orderID
</cfquery>
</cfoutput>
</cfif>
Thanks!
Samall...
Bookmarks