|
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 |