Hi,
I have try to retrieve data from a xml file. I write following code to query on xml. But don't get expected result. It return Zero nodeLenght.
Please help me.
Naznin Nahar.
MY code-
Code:
Set xmlDoc = Server.CreateObject("Microsoft.XMLDOM")
xmlDoc.async = false
xmlDoc.Load Server.MapPath("\Data\XML Data\strFile.xml")
set xmlNode =xmlDoc.selectNodes("//rs:data/z:row[(@C_ID=8 and @S_TYPE='Skill')]")
nodeLength=xmlNode.length
XML file -
<xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:schemas-microsoft-com:rowset'
xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
<s:ElementType name='row' content='eltOnly' rs:CommandTimeout='30'>
<s:AttributeType name='S_C_ID' rs:number='1'>
<s:datatype dt:type='int' dt:maxLength='4' rs:precision='10' rs:fixedlength='true' rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='C_ID' rs:number='2' rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='ui1' dt:maxLength='1' rs:precision='3' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='S_NAME' rs:number='3' rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='50'/>
</s:AttributeType>
<s:AttributeType name='S_TYPE' rs:number='4' rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='20'/>
</s:AttributeType>
<s:AttributeType name='SNO' rs:number='5' rs:nullable='true' rs:writeunknown='true'>
<s:datatype dt:type='ui1' dt:maxLength='1' rs:precision='3' rs:fixedlength='true'/>
</s:AttributeType>
<s:extends type='rs:rowbase'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row S_C_ID='688' C_ID='8' S_NAME='VIZ Render' S_TYPE='Skill'/>
<z:row S_C_ID='689' C_ID='8' S_NAME='GIS' S_TYPE='Skill'/>
<z:row S_C_ID='690' C_ID='8' S_NAME='CADD' S_TYPE='Skill'/>
<z:row S_C_ID='764' C_ID='2' S_NAME='Capital Market/Investment Banking' S_TYPE='Skill'/>
<z:row S_C_ID='765' C_ID='2' S_NAME='Remittance' S_TYPE='Skill'/>
<z:row S_C_ID='766' C_ID='2' S_NAME='International Banking' S_TYPE='Skill'/>
<z:row S_C_ID='767' C_ID='2' S_NAME='Syndicated Loan Management' S_TYPE='Skill'/>
<z:row S_C_ID='768' C_ID='4' S_NAME='Accounting' S_TYPE='Skill'/>
<z:row S_C_ID='820' C_ID='4' S_NAME='Media & Communication' S_TYPE='Skill'/>
<z:row S_C_ID='821' C_ID='4' S_NAME='Advertising' S_TYPE='Skill'/>
<z:row S_C_ID='822' C_ID='4' S_NAME='Photography' S_TYPE='Skill'/>
<z:row S_C_ID='335' C_ID='2' S_NAME='General Banking' S_TYPE='Work Area' SNO='1'/>
<z:row S_C_ID='376' C_ID='4' S_NAME='Teaching/Training' S_TYPE='Work Area' SNO='1'/>
<z:row S_C_ID='377' C_ID='4' S_NAME='Education Administration/Management' S_TYPE='Work Area' SNO='2'/>
<z:row S_C_ID='336' C_ID='2' S_NAME='Retail Banking' S_TYPE='Work Area' SNO='2'/>
<z:row S_C_ID='337' C_ID='2' S_NAME='Corporate' S_TYPE='Work Area' SNO='3'/>
<z:row S_C_ID='378' C_ID='4' S_NAME='Education Counseling' S_TYPE='Work Area' SNO='3'/>
<z:row S_C_ID='428' C_ID='8' S_NAME='Software Architect' S_TYPE='Work Area' SNO='3'/>
<z:row S_C_ID='429' C_ID='8' S_NAME='Project Manager (Software)' S_TYPE='Work Area' SNO='4'/>
<z:row S_C_ID='1012' C_ID='2' S_NAME='Relationship' S_TYPE='Work Area' SNO='34'/>
</rs:data>
</xml>
How to query on xml data
