MACROMEDIA COLDFUSION MX 61-DEVELOPING COLDFUSION MX, Develop Manual

Page: 693 / 860

Example: using XML in a ColdFusion application 693
The XML document
The order.xml document has the following structure:
•
The root element is named order and has one attribute, id.
•
There is one customer element with firstname, lastname, and accountnum attributes. The
customer element does not have a body
•
There is one items element that contains multiple item elements
•
Each item element has an id attribute and contains a name, quantity, and unitprice element.
The name, quantity, and unitprice elements contain their value as body text.
The following order.xml document works correctly with the information in the CompanyInfo
database:
<order id="4323251">
<customer firstname="Philip" lastname="Cramer" accountNum="21"/>
<items>
<item id="43">
<name>
Large Hammer
</name>
<quantity>
1
</quantity>
<unitprice>
15.95
</unitprice>
</item>
<item id="54">
<name>
Ladder
</name>
<quantity>
2
</quantity>
<unitprice>
40.95
</unitprice>
</item>
<item id="68">
<name>
Paint
</name>
<quantity>
10
</quantity>
<unitprice>
18.95
</unitprice>
</item>
</items>
</order>