Click to See Complete Forum and Search --> : How to filter Xml


skid_myanmar
March 29th, 2006, 04:50 AM
Hi all,
Here is sample Xml code, I just want to get "ROW/Col/Data" as one record by DataSet...I wanna omit all other tags...how can i acheive it...by Xsl/Xsd


<?xml version="1.0" encoding="UTF-8" ?>
<FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">
<ERRORCODE>
0</ERRORCODE>
<PRODUCT BUILD="02-10-2004" NAME="FileMaker Pro" VERSION="7.0v1"/>
<DATABASE DATEFORMAT="D/m/yyyy" LAYOUT="" NAME="ALL INVOICE 0607.fp7" RECORDS="186" TIMEFORMAT="k:mm:ss "/>
<METADATA>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Address" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Agent Cat" TYPE="TEXT"/>
</METADATA>
<RESULTSET FOUND="1">
<ROW MODID="95" RECORDID="3552">
<COL>
<DATA></DATA>
</COL>
<COL>
<DATA></DATA>
</COL>
<COL>
</ROW>
</RESULTSET>
</FMPXMLRESULT>


SKid