xml-dev - Re: Grouping

[Ronald Bourret <rpbourret@rpbourret.com>]

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