OK so please do not think I am a total idiot, however, I am curious on the most effective way to use the CFMX XML Query Tag.
 
Ideally I am looking to something like this:
 
<cffile action="" file="#request.RootDir#/__asset__/_xml_/cms_containers.xml" variable="GotXML">
 
<cf_xmlq name = "dothenav"
    xpath = "//[EMAIL PROTECTED]'#thisPage#'[EMAIL PROTECTED]'yes']/[EMAIL PROTECTED]'yes']|//[EMAIL PROTECTED]'#thisPage#'[EMAIL PROTECTED]'yes']/[EMAIL PROTECTED]'yes']/content"
    xml = "#GotXML#">
 
<cfquery name="SideNav" dbType="query">
  SELECT
    CONTAINER_NAME
  , CONTAINER_MENU
  , CONTENT_LABEL
  , CONTENT_LANDING
  FROM dothenav
  WHERE
  1=1
AND CONTAINER_MENU = 'yes'
AND CONTENT_LANDING = 'yes'
</cfquery>
 
<cfloop query="SideNav">
   #CONTAINER_NAME#|#CONTAINER_MENU#|#CONTENT_LABEL#<br>
</cfloop> 
 
However, I am not getting results.  Any help is appreciated.
 
 
 
Regards,
Michael J. Sammut

Reply via email to