How to Fill values of an XML File from DB -- Kumar

XML Experts,

I have a question based on the sample XML file as shown below:

How to get the values for lookup tags, or sequence tags in a Schema ?

<!-- Purchase Order -->
<PO>
<!-- Sequence Tag is as below -->
<PO_Number>Get the value from a databse sequence generator</PO_Number>

<!-- Lookup Tag is as Below -->
<PO_Type_ID>lookup database and get ID for Blanket PO Type</PO_Type_ID>

<PO_Authorization_Required>Yes</PO_Authorization_Required>
</PO>

Best Regards,
Kumar


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp