Sign Up
Search
Options
search
Chat
Help
News
Log in
Not Logged in
Home
»
Boards
»
Stylus Studio Developer Network
»
XSLT Help and Discussion
»
Looping through xml document
Topic
Topic Page
1
2
3
4
5
6
7
8
9
Prev Topic
Next Topic
next
Subject:
Looping through xml document
Author:
vt 101
Date:
29 Jul 2008 01:45 PM
This is my first post and I could really could do with some help, I'm a bit new to xsl!
I have an xml like so:
<document>
<data>
<row index=0>
<item_id>1</item_id>
<price>700.00<price>
<picture>1.jpg</picture>
<description>A blue vase</description>
</row>
<row index=1>
<item_id>2</item_id>
<price>600.00<price>
<picture>25.jpg</picture>
<description>A brass clock</description>
</row>
<row index=2>
<item_id>1</item_id>
<price>700.00<price>
<picture>2.jpg</picture>
<description>A blue vase</description>
</row>
<row index=3>
<item_id>1</item_id>
<price>700.00<price>
<picture>3.jpg</picture>
<description>A blue vase</description>
</row>
<row index=4>
<item_id>3</item_id>
<price>500.00<price>
<picture>21.jpg</picture>
<description>A ceramic bowl</description>
</row>
</data>
</document>
Basically what I need to do, is loop through this so I have a resulting xml document that has one row set for each item_id but includes all the pictures for the item_id as well as the other nodes. So the result would look like:
<document>
<data>
<row index=0>
<item_id>1</item_id>
<price>700.00<price>
<picture>1.jpg</picture>
<picture1>2.jpg</picture1>
<picture2>3.jpg</picture1>
<description>A blue vase</description>
</row>
<row index=1>
<item_id>2</item_id>
<price>600.00<price>
<picture>25.jpg</picture>
<description>A brass clock</description>
</row>
<row index=4>
<item_id>3</item_id>
<price>500.00<price>
<picture>21.jpg</picture>
<description>A ceramic bowl</description>
</row>
</data>
</document>
I have experimented with for-each and for-each-group in xslt 2.0 but cannot seem to figure this out.
Many Thanks in advance to anyone who can help me.
next
Subject:
Looping through xml document
Author:
(Deleted User)
Date:
30 Jul 2008 09:26 AM
What you want to do is a grouping operation based on the <description> node: have a look at
http://www.jenitennison.com/xslt/grouping/index.html
for the explanation of various techniques.
Alberto
top
Subject:
Looping through xml document
Author:
vt 101
Date:
30 Jul 2008 10:59 AM
I came across the method you quoted late last night and managed to implement it.
Very powerful and thanks for the tip!
Topic Page
1
2
3
4
5
6
7
8
9
Prev Topic
Next Topic
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:
Select Conference
Stylus Studio Feature Requests
Stylus Studio Technical Forum
Website Feedback
XSLT Help and Discussion
XQuery Help and Discussion
Stylus Studio FAQs
Stylus Studio Code Samples & Utilities
Stylus Studio Announcements
go
Log In Options
Username:
Password:
Site Map
|
Privacy Policy
|
Terms of Use
|
Trademarks
Stylus Scoop XML Newsletter:
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-2016 All Rights Reserved.