Hi All,

I have the following xml data and would like to combine the element <order> into a single line and treat it as an element in the <customer>.

How do I go about doing that in xdr? Or even if it is possible?

<root>

            <customer>

                        <id>123</id>

                        <name>smith</name>

                        <order partID=”j004” />

                        <order partID=”j024” />

            </customer>

</root>

TO SOMETHING LIKE THESE…..

<root>

            <customer>

                        <id>123</id>

                        <name>smith</name>

                        <partID>”j004 j024” <partID/>

            </customer>

</root>

I try the following in my xdr schema and it gives me error: “missing element definition 'partID’”

   <ElementType name="Customer"         sql:relation="Customer">

      <element type="id"              sql:field="CustID" />

      <element type="name"         sql:field="CustName" />

      <element type="partID"       sql:field="PartID" />

   </ElementType>

Thanks,

TA