[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Summarising XML datasets
Hi, I have a problem formatting some XML I am receiving from a 3rd party application that I cannot alter. The application is querying a database that has a table called photo and a table called photosubject, there is a one to many relationship between photo and photosubject. As a simple example, photo 1 is of a house and it has been deemed to cover subjects X, Y and Z. When I submit some arguments to the application I am getting an XML document in this format: <results> <photograph> <id>1</id> <name>House</name> <description>House 1</description> <subject>X</subject> </photograph> <photograph> <id>1</id> <name>House</name> <description>House 1</description> <subject>Y</subject> </photograph> <photograph> <id>1</id> <name>House</name> <description>House 1</description> <subject>Z</subject> </photograph> </results> What I want to do if possible is to render the information using xslt as: HouseID | House | Description | Subjects =========================================== 1 | House | House 1 | X, Y, Z Any ideas? Cheers, Chris
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|