Larry Brister
asked on
XML Select
I need to do (one of my first) select as XML statements
I need <?xml version="1.0" encoding="UTF-8" ?> at the top
Then the "root tag" is <Document>
Then a <Header> section with hard coded nodes
Then a <Record> section with firstname, lastname etc nodes
Example would be (selecting first and last name from r_users).
<?xml version="1.0" encoding="UTF-8" ?>
<Document>
<XMLVersion Version="2.00"/>
<Header>
<PacketNum>000000011122255 5</PacketN um>
blah...blah..blah...
</Header>
<Record>
<SeqNum>1</SeqNum>
<firstName>Bill</firstName >
<lastName>Gates</lastName>
blah..blah..blah...
</Record>
</Document>
I need <?xml version="1.0" encoding="UTF-8" ?> at the top
Then the "root tag" is <Document>
Then a <Header> section with hard coded nodes
Then a <Record> section with firstname, lastname etc nodes
Example would be (selecting first and last name from r_users).
<?xml version="1.0" encoding="UTF-8" ?>
<Document>
<XMLVersion Version="2.00"/>
<Header>
<PacketNum>000000011122255
blah...blah..blah...
</Header>
<Record>
<SeqNum>1</SeqNum>
<firstName>Bill</firstName
<lastName>Gates</lastName>
blah..blah..blah...
</Record>
</Document>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER