SSDN - Repeating element question

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

Jon Accornero

Subject: Repeating element question
Author: Jon Accornero
Date: 28 Nov 2007 10:43 AM

I am using the XML report utility and have an xml file that looks something like this

<Item>
<ItemNumber>1</ItemNumber>
</Item>
<ItemDetail>
<Qty>100</Qty>
</ItemDetail>
<Item>
<ItemNumber>2</ItemNumber>
</Item>
<ItemDetail>
<Qty>200</Qty>
</ItemDetail>
<Item>
<ItemNumber>3</ItemNumber>
</Item>
<ItemDetail>
<Qty>300</Qty>
</ItemDetail>

When I drag and drop the ItemNumber and Qty on the canvas, it gives me the following output
1
100
200
300
2
100
200
300
3
100
200
300

Basically, the Qty element repeats everytime for each Item element. I'm not sure how to correct this. Any thoughts?

Thanks,

Jon

Alberto Massari

Subject: Repeating element question
Author: Alberto Massari
Date: 30 Nov 2007 05:08 AM

Hi Jon,
I think that, when you dragged the Qty field inside the table, you have chosen to insert a new repeater block; so, at each iteration of ItemNumber, you iterate over all the Qty's.
You should just drag Item (creating a repeater - or table, or list - for this), then drag ItemNumber and Qty, choosing 'insert value'.

Hope this helps,
Alberto

Topic Page 1 2 3 4 5 6 7 8 9

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2011 All Rights Reserved.