[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: Grouping
What product are you using to transfer your data from the database (ADO, XML-DBMS, XML SQL Utility for Java, any one of many Web page template languages, etc.)? Assuming your data is in a relational database and your schema looks something like this: Table: Products Column: ProductID Table: Properties Columns: ProductID codetype code it should be very easy to generate XML that looks like this: <order> <product> <id>1</id> <codetype>COLOR</codetype> <code>RED</code> <codetype>SIZE</codetype> <code>LARGE</code> </product> </order> or like this: <order> <product> <id>1</id> <properties> <codetype>COLOR</codetype> <code>RED</code> </properties> <properties> <codetype>SIZE</codetype> <code>LARGE</code> </properties> </product> </order> -- Ron Bourret cgfield wrote: > > Hello, > > I have looked for the answer to this question, that seems like it would be a > common problem, but I cannot find an answer that works. > > I have a database that stores a product with a unique ID. This product can > have several properties. Thus I will get an xml string that looks like the > following. > > <order> > <product> > <id>1</id> > <codetype>COLOR</codetype> > <code>RED</code> > </product> > <product> > <id>1</id> > <codetype>SIZE</codetype> > <code>LARGE</code> > </product> > </order> > > Unfortunately, when I transform this, it appears as two products. I want to > display one product with all of its attributes. -- Ronald Bourret Programming, Writing, and Training XML, Databases, and Schemas http://www.rpbourret.com
|
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
|