This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
Displaying Descriptions Based on Codes
- From: "Katie McNally" <kmcnally9 at hotmail dot com>
- To: xsl-list at lists dot mulberrytech dot com
- Date: Thu, 14 Mar 2002 17:33:19 -0600
- Subject: [xsl] Displaying Descriptions Based on Codes
- Reply-to: xsl-list at lists dot mulberrytech dot com
The XML that I get back after posting to a vendor contains data for a set of
transactions. I am displaying each transaction as a row in a table. One of
the columns needs to show the Transaction Description. This value is not
part of the XML data returned. Instead, for each transaction, a code
(Nm=CODE") is returned. The numeric value for the tag is the code, and is
associated to a description. Right now we have a spreadsheet of what all
the codes and there corresponding descriptions are.
How do I display the description for each transaction using XSL when the xml
contains only the code?
Here is an example of what the XML I get back looks like:
<Result>
<TransSet>
<Transaction Index="1">
<Tg Nm="INTEREST_RT">7.345</Tg>
<Tg Nm="PRINCIPAL">100000.00</Tg>
<Tg Nm="BALANCE">20000.00</Tg>
<Tg Nm="CODE">13</Tg>
</Transaction>
<Transaction Index="2">
<Tg Nm="INTEREST_RT">7.045</Tg>
<Tg Nm="PRINCIPAL">200000.00</Tg>
<Tg Nm="BALANCE">70000.00</Tg>
<Tg Nm="CODE">45</Tg>
</Transaction>
<Transaction Index="3">
<Tg Nm="INTEREST_RT">6.945</Tg>
<Tg Nm="PRINCIPAL">150000.00</Tg>
<Tg Nm="BALANCE">10000.00</Tg>
<Tg Nm="CODE">17</Tg>
</Transaction>
...
</TransSet>
</Result>
Below is an example of the Codes and their Descriptions:
Code - Description
1 - Escrow Advance
2 - Escrow Deposit
...
13 - Fee Transaction
...
17 - Payment
...
45 - Adjustment
Thanks, Katie
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list