<span style='font-size:
10.0pt;font-family:Arial;color:navy'>Hi All,<o:p></o:p>

<span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p>

<span style='font-size:10.0pt;
font-family:Arial'>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>.<o:p></o:p>

<span style='font-size:10.0pt;
font-family:Arial'>How do I go about
doing that in xdr? Or even if it is possible?<o:p></o:p>

<span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p>

<span style='font-size:
10.0pt;font-family:Arial;color:navy'><root><o:p></o:p>

<span style='font-size:
10.0pt;font-family:Arial;color:navy'>           
<customer><o:p></o:p>

<span style='font-size:
10.0pt;font-family:Arial;color:navy'>                       
<id>123</id><o:p></o:p>

<span style='font-size:
10.0pt;font-family:Arial;color:navy'>                       
<name>smith</name><o:p></o:p>

<span style='font-size:
10.0pt;font-family:Arial;color:navy'>                       
<order partID=”j004” /><o:p></o:p>

<span style='font-size:
10.0pt;font-family:Arial;color:navy'>                       
<order partID=”j024” /><o:p></o:p>

<span style='font-size:
10.0pt;font-family:Arial;color:navy'>           
</customer><o:p></o:p>

<span style='font-size:
10.0pt;font-family:Arial;color:navy'></root><o:p></o:p>

<span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p>

<span style='font-size:10.0pt;
font-family:Arial'>TO SOMETHING LIKE THESE…..<o:p></o:p>

<span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p>

<span style='font-size:
10.0pt;font-family:Arial;color:navy'><root><o:p></o:p>

<span style='font-size:
10.0pt;font-family:Arial;color:navy'>           
<customer><o:p></o:p>

<span style='font-size:
10.0pt;font-family:Arial;color:navy'>                       
<id>123</id><o:p></o:p>

<span style='font-size:
10.0pt;font-family:Arial;color:navy'>                       
<name>smith</name><o:p></o:p>

<span style='font-size:
10.0pt;font-family:Arial;color:navy'>                       
<partID>”j004 j024” <partID/><o:p></o:p>

<span style='font-size:
10.0pt;font-family:Arial;color:navy'>           
</customer><o:p></o:p>

<span style='font-size:
10.0pt;font-family:Arial;color:navy'></root><o:p></o:p>

<span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p>

<span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p>

<span style='font-size:10.0pt;
font-family:Arial'>I try the following in my xdr schema and it gives me error:
“missing element definition 'partID’”<o:p></o:p>

<span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p>

<span style='font-size:
10.0pt;font-family:Arial;color:navy'>   <ElementType
name="Customer"        
sql:relation="Customer"><o:p></o:p>

<span style='font-size:
10.0pt;font-family:Arial;color:navy'>      <element
type="id"             
sql:field="CustID" /><o:p></o:p>

<span style='font-size:
10.0pt;font-family:Arial;color:navy'>      <element
type="name"        
sql:field="CustName" /><o:p></o:p>

<span style='font-size:
10.0pt;font-family:Arial;color:navy'>      <element
type="partID"      
sql:field="PartID" /><o:p></o:p>

<span style='font-size:
10.0pt;font-family:Arial;color:navy'>   </ElementType><o:p></o:p>

<span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p>

<span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p>

<span style='font-size:10.0pt;
font-family:Arial'>Thanks,<o:p></o:p>

<span style='font-size:10.0pt;
font-family:Arial'>TA<o:p></o:p>

<span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p>

<span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p>