Newbie Questions

Re: Trying to filter with XPath

Potemkine — Mon, 09 Aug 2010 19:11:25 GMT

You're Welcome Pinback :)

Re: Trying to filter with XPath

Pinback — Mon, 09 Aug 2010 19:07:46 GMT

BINGO! :)

You did it, Potemkine! Thanks so much! :) :)

Pinback

Re: Trying to filter with XPath

Potemkine — Mon, 09 Aug 2010 19:02:14 GMT

Hi, if Facility is an attribute try this :

NI = DOM.Select("/dfs:myFields/dfs:dataFields/dfs:"My_Secondary_DataSource"[@Facility='Mary']", Me.NamespaceManager)

Re: Trying to filter with XPath

Pinback — Mon, 09 Aug 2010 18:51:42 GMT

Hello Potemkine :)

When I try:

NI = DOM.Select("/dfs:myFields/dfs:dataFields/dfs:"My_Secondary_DataSource"[Facility='Mary']", Me.NamespaceManager)

it reads the code, but the following line:

MsgBox(NI.Count)

returns a value of 0 despite the fact there are 4 instance of Mary in "My_Secondary_DataSource".

Re: Trying to filter with XPath

Potemkine — Mon, 09 Aug 2010 18:43:25 GMT

Hi, Pinback and if you try:

NI = DOM.Select("/dfs:myFields/dfs:dataFields/dfs:My_Secondary_DataSource", me.NameSpaceManager)

Trying to filter with XPath

Pinback — Mon, 09 Aug 2010 18:24:33 GMT

Hello,

I am attempting to set up a filter using xPath and a Secondary DataSource (no filter applied as of yet).

Dim DOM As Xml.XPath.XPathNavigator
Dim NI As System.Xml.XPath.XPathNodeIterator
Dim expr As XPathExpression

DOM = Me.DataSources("My_Secondary_DataSource").CreateNavigator
expr = DOM.Compile("/dfs:myFields/dfs:dataFields/dfs:My_Secondary_DataSource")
NI = DOM.Select(expr)

On the last line of code, I receive the error "Namespace Manager or XsltContext needed. This query has a prefix, variable, or user-defined function."

If I change the last line of code to "NI = DOM.Select(expr, me.NameSpaceManager)", I get an error stating "Error 8 Value of type 'System.Xml.XPath.XPathExpression' cannot be converted to 'String'".

Any thoughts on how to fix this error?

Thanks in advance,

Pinback