GetListItems SelectNodes not working for me

[Steve]

I am getting no nodes from the following code:

'Put user code to initialize the page here
Dim listService As New com.domain.my.L ists
listService.Cre dentials =
System.Net.Cred entialCache.Def aultCredentials
Dim xmlDoc = New System.Xml.XmlD ocument

Dim ndQuery As XmlNode = xmlDoc.CreateNo de(XmlNodeType. Element,
"Query", "")
Dim ndViewFields As XmlNode = xmlDoc.CreateNo de(XmlNodeType. Element,
"ViewFields ", "")
Dim ndQueryOptions As XmlNode =
xmlDoc.CreateNo de(XmlNodeType. Element, "QueryOptio ns", "")

ndQueryOptions. InnerXml =
"<IncludeMandat oryColumns>FALS E</IncludeMandator yColumns>" + _
"<DateInUtc>TRU E</DateInUtc>"
ndViewFields.In nerXml = "<FieldRef Name='Title'/><FieldRef
Name='URL'/><FieldRef Name='Category'/>"
ndQuery.InnerXm l = ""

Try

Dim ndListItems As XmlNode = listService.Get ListItems("Tool bar",
Nothing, ndQuery, ndViewFields, Nothing, ndQueryOptions)

Dim doc As XmlDocument = New XmlDocument
doc.LoadXml(Rep lace(ndListItem s.InnerXml, ControlChars.Lf &
ControlChars.Lf , ""))
Dim nsmgr As XmlNamespaceMan ager = New
XmlNamespaceMan ager(doc.NameTa ble)
nsmgr.AddNamesp ace("z", "#RowsetSchema" )
nsmgr.AddNamesp ace("rs", "urn:schema s-microsoft.com:r owset")
Dim node As XmlNode
Dim xl As XmlNodeList = doc.SelectNodes ("/rs:data/z:row", nsmgr)
For Each node In xl
Debug.WriteLine (node.Attribute s("ows_Title" ))
Next
Debug.WriteLine (ndListItems.In nerXml)

Catch ex As System.Web.Serv ices.Protocols. SoapException

Debug.WriteLine ("Message:" & vbCrLf & ex.Message + vbCrLf +
"Detail:" + vbCrLf + ex.Detail.Inner Text + ControlChars.Lf + "StackTrace :" +
ControlChars.Lf + ex.StackTrace)
End Try

The following is the Outer XML that I am receiving back, which clearly has
records.

<listitems xmlns:s="uuid:B DC6E3F0-6DA3-11d1-A2A3-00AA00C14882"
xmlns:dt="uuid: C2F41010-65B3-11d1-A29F-00AA00C14882"
xmlns:rs="urn:s chemas-microsoft-com:rowset" xmlns:z="#Rowse tSchema"
xmlns="http://schemas.microso ft.com/sharepoint/soap/">

<rs:data ItemCount="3">
<z:row ows_Title="Yaho o" ows_URL="http://www.yahoo.com"
ows_Category="S ites" ows_ID="1" ows_owshiddenve rsion="1" />
<z:row ows_Title="Goog le" ows_URL="http://www.google.com"
ows_Category="T ools" ows_ID="2" ows_owshiddenve rsion="1" />
<z:row ows_Title="Shar ePoint Help"
ows_URL="/_vti_bin/help/1033/sps/html/SharePointHelp. htm" ows_Category="H elp"
ows_ID="3" ows_owshiddenve rsion="3" />
</rs:data>
</listitems>

Am I missing something?

Thanks!

[Derek Harmon]

"Steve" <St***@discussi ons.microsoft.c om> wrote in message news:04******** *************** ***********@mic rosoft.com...

I am getting no nodes from the following code: : : nsmgr.AddNamesp ace("rs", "urn:schema s-microsoft.com:r owset") : : xmlns:rs="urn:s chemas-microsoft-com:rowset" xmlns:z="#Rowse tSchema" : : Am I missing something?

It all seems to be in order, except that the xmlns declaration of rs in the
instance document is

urn:schemas-microsoft-com:rowset

whereas the xmlns declaration you've added to the XmlNamespaceMan ager
is

urn:schemas-microsoft.com:r owset

If you look closely, you'll observe a dot-com in this namespace URI
whereas the URN has dash-com. This revision should help,

nsmgr.AddNamesp ace("rs", "urn:schema s-microsoft-com:rowset")
Derek Harmon

[Steve]

Derek,

Thank you very much! Even after reading your email I didn't see it right
away, but that did it.

Steve

"Derek Harmon" <lo*******@msn. com> wrote in message
news:eS******** ******@TK2MSFTN GP14.phx.gbl...

"Steve" <St***@discussi ons.microsoft.c om> wrote in message
news:04******** *************** ***********@mic rosoft.com...

I am getting no nodes from the following code:

: :

nsmgr.AddNamesp ace("rs", "urn:schema s-microsoft.com:r owset")

: :

xmlns:rs="urn:s chemas-microsoft-com:rowset" xmlns:z="#Rowse tSchema"

: :

Am I missing something?

It all seems to be in order, except that the xmlns declaration of rs in
the
instance document is

urn:schemas-microsoft-com:rowset

whereas the xmlns declaration you've added to the XmlNamespaceMan ager
is

urn:schemas-microsoft.com:r owset

If you look closely, you'll observe a dot-com in this namespace URI
whereas the URN has dash-com. This revision should help,

nsmgr.AddNamesp ace("rs", "urn:schema s-microsoft-com:rowset")
Derek Harmon

[ckfinley]

I am having a similar problem getting blank nodes. I have attached m
code (C#)

+----------------------------------------------------------------
| Attachment filename: code.txt
|Download attachment: http://www.mcse.ms/attachment.php?postid=3566859
+----------------------------------------------------------------

-
ckfinle
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message1285233.htm