Skip to main content
WolfShade
WolfShade
Legend
June 27, 2011
Answered

Working with XML

  • June 27, 2011
  • 1 reply
  • 473 views

Hello, everyone.

I'm trying to build a module that will take  XML that is inserted into a variable with XMLparse() from an uploaded  .xml document, and go through ALL child nodes.  Each node needs to be  checked to see if a particular parameter is contained within (ID, or  Name, or Size, etc.)  Any node that contains one of the sought-after  parameters, I need to get the value of that parameter (integer) and add  it mathematically to an initialized variable that starts at 0.

Is there a built-in CF function (or a UDF) that will do this?  Or will I have to build a multiple-nested loop to check for this?

Thanks,

^_^

    This topic has been closed for replies.
    Correct answer Adam Cameron.
    Since I will not know in advance which nodes will or will not have Children, nor whether or not any of the Children will have the name or id parameter, how do I determine if a node has an array OR a parameter?

    Read up on xpath first.  Then ask questions like this after that.

    --

    Adam

    1 reply

    A
    Adam Cameron.
    Inspiring
    June 27, 2011

    No.  There will be no special built-in CF function to automatically fulfil you're specific XML schema and requirements.  CF is good but it ain't that good.

    However one can use xmlSearch() to do an xpath search to extract subsets of nodes / attributes as an array, which one can then loop over fairly easily to tally up whatever it is you need to do.

    --

    Adam

    WolfShade
    WolfShadeAuthor
    Legend
    June 27, 2011

    Thanks, Adam.  I'll look into xmlSearch().

    Meanwhile, let me post some example XML data. 

    <rootElement>
      <DataA>
        <ChildA>
          <Child1 name="this" id="1"/>
        </ChildA>
        <ChildB>
          <Child1>
            <Grandchild1 name="that" id="2"/>
          </Child1>
        </ChildB>
        <ChildC>
          <Child1>
            <Grandchild1>
              <AnotherGrandchild name="where" id="9"/>
              <AnotherGrandchild1 name="when" id="12"/>
            </Grandchild1>
            <Grandchild2>
              <AnotherGrandchild1>
                <KeepGoing>
                  <Anymore name="whendoesitend" id="3"/>
                </KeepGoing>
              </AnotherGrandchild1>
            </Grandchild2>
          </Child1>
          <Child2/>
        </ChildC>
     </DataA>

    Since I will not know in advance which nodes will or will not have Children, nor whether or not any of the Children will have the name or id parameter, how do I determine if a node has an array OR a parameter?  I assume ArrayLen for the array (0 = no children?)  What about the parameters?  Check for isDefined?

    Thanks,

    ^_^

    A
    Adam Cameron.Correct answer
    Inspiring
    June 27, 2011
    Since I will not know in advance which nodes will or will not have Children, nor whether or not any of the Children will have the name or id parameter, how do I determine if a node has an array OR a parameter?

    Read up on xpath first.  Then ask questions like this after that.

    --

    Adam

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices