2 Replies Latest reply on Aug 26, 2011 11:29 PM by Subba560

    Adding a node through XPath

    Subba560

      Hi i am giving below xml as input to the form

       

      <root>
      <FirstName></FirstName>
      <EmpNumber></EmpNumber>
      <language>
            <lang>
                     </data>

            <l/ang>
      </planguage>
      </root>

       

      lang is the repeating node and data is dropdown

       

      I am using mutiple Query to rettive the rows form database  and  output is the xml below

       

      <language>
            <lang>
                   <data type="VARCHAR">English</data>
            </lang>
             <lang>
                   <data type="VARCHAR">UK</data>
            </lang>
             <lang>
                   <data type="VARCHAR">India</data>
            </lang>
             <lang>
                   <data type="VARCHAR">AUstralia</data>
            </lang>
             <lang>
                   <data type="VARCHAR">Africa</data>
            </lang>
            <lang>
                   <data type="VARCHAR">Wesindies</data>
            </lang>
      </language>

       

       

      Now i want to merge these two XMLs and my output should be as below

       

      <root>
      <FirstName></FirstName>
      <EmpNumber></EmpNumber>
      <language>
            <lang>
                   <data type="VARCHAR">English</data>
            </lang>
             <lang>
                   <data type="VARCHAR">UK</data>
            </lang>
             <lang>
                   <data type="VARCHAR">India</data>
            </lang>
             <lang>
                   <data type="VARCHAR">AUstralia</data>
            </lang>
             <lang>
                   <data type="VARCHAR">Africa</data>
            </lang>
            <lang>
                   <data type="VARCHAR">Wesindies</data>
            </lang>
      </language>

      </root>

       

      Please help me out wht is the procedure to the above xml result ,   so i can bind the to the for to diapaly in dropdown.

       

       

       

      Thanks in advance

      bala