2 Replies Latest reply on Mar 6, 2008 1:49 PM by unleashed

    XML to Query Error

    unleashed Level 1
      I have an XML document that I'm trying to turn into a query, but I'm getting an error: "Element P is undefined in MYDOC." I have an element called "P-Info" and I think that the code doesn't like the dash.

      I am trying to extract the TS, Latitude, Longitude and Own values out of the XML document.

      I'm using CFMX 7.





        • 1. Re: XML to Query Error
          Level 7
          unleashed wrote:
          > I have an XML document that I'm trying to turn into a query, but I'm getting an
          > error: "Element P is undefined in MYDOC." I have an element called "P-Info"
          > and I think that the code doesn't like the dash.
          >
          > I am trying to extract the TS, Latitude, Longitude and Own values out of the
          > XML document.
          >
          > CFML Document:
          >
          > <cffile action="read" variable="xml" file="#ExpandPath('.')#\sample.xml">
          > <CFSet mydoc = XMLParse(xml)>
          > <cfset pb = mydoc.META.P-Info.xmlChildren>
          > <cfdump var="#pb#">

          Yes, when you use dot notation every element must be a valid ColdFusion
          variable name which means no spaces, dashes, ect.

          If you have elements like this you must use array notation.
          I.E. <cfset pb = mydoc["meta"]["p-info"]["xmlChildren"]>

          OR if you don't mind mixing dot and array notation.
          <cfset pb= myDoc.meta["p-info"].xmlChildren>
          • 2. Re: XML to Query Error
            unleashed Level 1
            Thanks Ian... I thought that it was probably the "d" (dash) that was causing the issue.