MQSeries.net :: View topic

rajaram · Posted: Tue Mar 30, 2004 7:16 am Post subject:

Hi,
I have never seen such a problem in my life.

Problem 1:
If i parse XML message in MRM Domain i cannot access attributes of XML elements in compute node .I have to use '@', before attribute.This works fine.
eg:For XML data
<level1>
<level2 id='123'></level>
</level1>

if i refer to 'id' as "level1"."level2"."@id" in ESQL....it works perfectly.....But this is not the case with all attributes.

. I have to check in debugger or in trace node to really check if th attribute is preceded b "@".Only then i can use "@"...else without '@' itr works fine.....

Problem2:

declare T as Environment.Variables.FlowSpecific."class"[];

SET temp = THE(SELECT ITEM R."avText"."value" FROM T."at"[] as R WHERE R."@id" = '437');

This statement works fine as long as "437" anywhere in first <class>.

eg:
<class id="1">
<desc>Physical</desc>
<at id="114">
<desc>PACKAGING TYPE</desc>
<avText id="2028401">
<value>fghfgh</value>
</avText>
</at>
<at id="437">
<desc>vbcbvcvbcb</desc> <avText id="4948">
<value>1 COLOUR</value>
</avText>
</at>
<at id="949">
<desc>PRODUCT WIDTH - MM (GDD)</desc>
<avText id="10545">
<value>49.000</value>
</avText>
</at>
<at id="950">
<desc>PRODUCT DEPTH - MM (GDD)</desc>
<avText id="10653">
<value>49.000</value>
</avText>
</at>
</class>
<class id="2">
<at id="951">
<desc>PRODUCT WIDTH - MM (GDD)</desc>
<avText id="10545">
<value>49.000</value>
</avText>
</at>
<at id="952">
<desc>PRODUCT DEPTH - MM (GDD)</desc>
<avText id="10653">
<value>49.000</value>
</avText>
</at>
</class>

BUT
if i use
declare T as Environment.Variables.FlowSpecific."class"[1].at[];

SET temp = THE(SELECT ITEM T."avText"."value" FROM T WHERE T."@id" = '437');

This will not work..
i.e.Now this will just search at[1]...(first at[]) in class[1].

Can anyone please explain me these two behaviour of SELECT Statement????
Thanks in advance[/i]