Recent

Author Topic: Work with a part of main XML document  (Read 2978 times)

Dane

  • New Member
  • *
  • Posts: 15
Work with a part of main XML document
« on: November 19, 2010, 08:29:14 am »
Hello, world! :0)
I've read XML file. Then I need to work with part of it.

Example:
Code: [Select]
<?xml version="1.0"?>
<parts>
   <part name="Part 1">
      <query>
         <MSQuery>SELECT * FROM t1</MSQuery>
         <MySQLQuery>INSERT * INTO mt1</MySQLQuery>
      </query>
...
      <query>
         <MSQuery>SELECT * FROM tn</MSQuery>
         <MySQLQuery>INSERT * INTO mtn</MySQLQuery>
      </query>
   </part>

...

   <part name="Part N">
      <query>
         <MSQuery>SELECT * FROM t1</MSQuery>
         <MySQLQuery>INSERT * INTO mt1</MySQLQuery>
      </query>
...
      <query>
         <MSQuery>SELECT * FROM tn</MSQuery>
         <MySQLQuery>INSERT * INTO mtn</MySQLQuery>
      </query>
   </part>
</parts>

I need to select all nodes with name 'part' and then, in each of them, select all nodes with name 'query' to work with them apart (to searching for node names, take a values and etc).

Can you help me with ideas?

 

TinyPortal © 2005-2018