MQSeries.net :: View topic - Accessing XML attributes in namespace assigned XML -> Sol

Rodeo · Posted: Wed Apr 11, 2007 8:54 am Post subject:

I am trying to access an attribute inside an XML document that has namespace assigned. The structure of XML put on the queue is as follows:

<?xml version="1.0" encoding="UTF-8"?>
<ns0:EXPERIMENT xmlns:ns0="http://www.yahoo.com">
<RESULT>
<RESPONSE1>POSITIVE</RESPONSE1>
<RESPONSE2>NEGATIVE</RESPONSE2>
<ID>1</ID>
</RESULT>
</ns0:EXPERIMENT>

I tried the following in ESQL code in the filter node. :

DECLARE sp1 NAMESPACE "http://www.yahoo.com"

IF Root.XMLNSC.sp1:EXPERIMENT.sp1:RESULT.sp1:ID1 = '1' THEN
RETURN TRUE;
ELSE
RETURN FALSE;
END IF;

It doesn't access the field and returns false. This is with XMLNSC parser.

Any thoughts or suggestions?