Problem with xpath function

Phanikumar · May 22nd, 2008, 02:08 AM

I have to retreive an xml element using an xpath query it is working fine if i give the query in this manner
Message_3=xpath(Message_2,"string(/*[local-name()='DataItems' and namespace-uri()='']/*[local-name()='DataItem' and namespace-uri()='']/*[local-name()='ItemName' and namespace-uri()=''][12])");
but giving a null value if given the query in this way
Variable_1=System.String.Format("/*[local-name()='DataItems' and namespace-uri()='http://BizTalk_Server_Project14.Schema3']/*[local-name()='DataItem' and namespace-uri()='']/*[local-name()='ItemName' and namespace-uri()=''][{0}]",8);
Message_3=xpath(Message_2,"string(Variable_1)");
Please suggest some solution for this.

joefawcett · May 22nd, 2008, 02:32 AM

I don't follow this, the first example is retrieving an element based on one xpath the second creates a completely different xpath but tyen discards it and uses the xpath of "Variable_1" as a string. I think you need:

Code:

Message_3=xpath(Message_2,"string(" + Variable_1 + ")");

--

Joe (Microsoft MVP - XML)