xml loop threw file

[Guest]

How can I loop threw and display 2 records as separate and store into db. thanx

<Row>
<employee>
<id>232</id>
<firstname>Test1</firstname>
<lastname>test2</lastname>
</employee>
<employee>
<id>231</id>
<firstname>Test1</firstname>
<lastname>test2</lastname>
</employee>
</row>

[Guest]

See if this helps:

<cfxml variable="myXml">
<row>
<employee>
<id>232</id>
<firstname>Test1</firstname>
<lastname>test2</lastname>
</employee>
<employee>
<id>231</id>
<firstname>Test1</firstname>
<lastname>test2</lastname>
</employee>
</row>
</cfxml>

<cfoutput>


<cfloop from="1" to="#ArrayLen(XmlSearch(myXml, '//employee'))#" index="i">
<cfloop from="1" to="#ArrayLen(myXml.row.employee .xmlChildren)#" index="j">
#myXml.row.employee.xmlChildren.xmlName# : #myXml.row.employee .xmlChildren.xmlText#<br />
</cfloop>
<hr />
</cfloop>

</cfoutput>

[Guest]

doesn't work . It is getting same output. If you put different value in firstname and lastname it is not getting correct result. it is getting same result even if you change value for first name and lastname in second time.