xml dom

[amiw]

hi, i am getting an error when i am accessing the R node in an xml file, below is the typical data found in the R node. the line that seems to be causing the problem is this one Response.Write(Node.selectSingleNode("R&quot.text)

'--- one of the R nodes in the xml file
<R>
- <![CDATA[

http://24.222.16.141/search/xml/Mon...GC6wos|ytMWQcdQoCFDG
&jid=GASTA_3647&st=video

]]>
</R>


''' a snippet of my code
Set objRoot = objDom.documentElement
For iCount= 1 to CInt(resultLength)
set Node = objRoot.selectSingleNode(&quot;RESULTS/SITE[@I=&quot; & CInt(iCount)& &quot;]&quot
Response.Write(Node.selectSingleNode(&quot;R&quot.value)
Next

anyone got any ideas?
thanks
Mic.

 

[chiph]

Are you in VB6 or .NET?

If in VB6, do this:

Dim MyMode As MSXML2.IXMLDOMNode
Dim sText as string

MyNode = Node.selectSingleNode("R")
If MyNode Is Nothing Then
  ' Didn't find R node
Else
  sText = MyNode.Text
End If
Response.Write(sText)

If you're in .NET, you should be aware that the text node is no longer implicitly provided to you via the .Text property. You must either use the &quot;text()&quot; function in your XPath query, or check the child nodes for nodes of type XmlText. The XPath route is easiest (sample is in C#, sorry):

XmlNode RNode;
RNode = MyDoc.SelectSingleNode("RESULTS/SITE[@I=" + iCount.ToString() + "]/text()");
if (RNode == null) {
  // Didn't find R Node
}
else
{
   Response.Write(RNode.Value);
}

Chip H.