|
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]'[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 =3D 'yes' AND CONTENT_LANDING =3D '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 |
