xsl-list
[Top] [All Lists]

RE: genarate key using a variable

2003-09-01 02:02:11
Thank you David & Mukund. But my problem is bit tricky... 
I have an xml like the below. & I have to filter the based any of attributes's  
value. That is the user can specify that which of the columns' data he wud like 
to filter based of any that column's values. Something like excel sheet data 
filter. So that's where exactly I am stuck as I unable to figure out how to 
have both the attribute & its value as parameter.
Also, the numbers of Columns C1, C2 etc are not limited

<?xml version="1.0"?>

<PickList>
        <TotalRows>33</TotalRows>
        <Columns C1="Deposit" C2="Period" C3="Status" C4="Value Date" 
C5="Maturity Date" C6="Deposit No"/>
        <Tags>ctlMskDepositNo *</Tags>
        <Rows>
                <Row C1="1" C2="1" C3="Closed Today" C4="23/10/2003" 
C5="23/04/2004" C6="1"/>
                <Row C1="2" C2="1" C3="Open Today" C4="06/11/2003" 
C5="05/01/2004" C6="2"/>
                <Row C1="3" C2="1" C3="Open Today" C4="29/02/2004" 
C5="29/04/2004" C6="3"/>
                <Row C1="7" C2="1" C3="Matured" C4="29/02/2004" C5="29/04/2004" 
C6="7"/>
                <Row C1="8" C2="1" C3="Closed" C4="29/02/2004" C5="29/04/2004" 
C6="8"/>
                <Row C1="9" C2="1" C3="Closed" C4="29/02/2004" C5="29/04/2004" 
C6="9"/>
                <Row C1="10" C2="1" C3=" Matured" C4="29/02/2004" 
C5="29/04/2004" C6="10"/>
                <Row C1="11" C2="1" C3="Open Today" C4="29/02/2004" 
C5="19/04/2004" C6="11"/>
                <Row C1="16" C2="1" C3="Open Today" C4="29/02/2004" 
C5="29/04/2004" C6="16"/>
                <Row C1="17" C2="1" C3="Open Today" C4="29/02/2004" 
C5="29/04/2004" C6="17"/>
                <Row C1="18" C2="1" C3="Open Today" C4="29/02/2004" 
C5="29/04/2004" C6="18"/>
                <Row C1="19" C2="1" C3="Closed" C4="29/02/2004" C5="19/04/2004" 
C6="19"/>
                <Row C1="32" C2="1" C3="Open Today" C4="29/02/2004" 
C5="09/04/2004" C6="32"/>
                <Row C1="33" C2="1" C3="Open Today" C4="29/02/2004" 
C5="30/03/2004" C6="33"/>
        </Rows>
</PickList>
Regards,
aruniima

 -----Original Message-----
From:   M. David Peterson [mailto:conners_dad(_at_)msn(_dot_)com] 
Sent:   Monday, September 01, 2003 1:56 PM
To:     xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject:        Re: [xsl] genarate key using a variable

I forgot that I needed to send this message in plain text format.  If the 
other one gets through I apologize for the repeat mail...

Original text of my email....

Hey Aruniima,

You've stumbled upon one that puzzled me for awhile.  But I finally came up 
with a quick and easy workaround.  Im sure there are others but this one is 
simple and it works which are my number one rules of coding.

My assumption is that the number of choices the user has as far as node 
names is fairly limited (e.g. Deposits, Withdrawls, etc...) and as such it 
should be a quick and easy task for the xsl:choose element...

heres the xml file...

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="transactions.xslt" ?>
<transactions>
    <deposits>
        <deposit id="001">25.00</deposit>
        <deposit id="002">25.00</deposit>
        <deposit id="003">35.00</deposit>
        <deposit id="004">10.00</deposit>
        <deposit id="005">12.00</deposit>
        <deposit id="006">25.00</deposit>
        <deposit id="007">25.00</deposit>
    </deposits>
    <withdrawals>
        <withdrawal id="001">5.00</withdrawal>
        <withdrawal id="002">2.00</withdrawal>
        <withdrawal id="003">5.00</withdrawal>
        <withdrawal id="004">10.00</withdrawal>
        <withdrawal id="005">12.00</withdrawal>
        <withdrawal id="006">250.00</withdrawal>
        <withdrawal id="007">250.00</withdrawal>
    </withdrawals>
</transactions>



and heres the related xslt file named transactions.xslt....  just change the 
variables accordingly


<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
      xmlns:xsl="http://www.w3.org/1999/XSL/Transform"; >

<xsl:variable name="var_1">deposit</xsl:variable>
<xsl:variable name="var_2">25.00</xsl:variable>
<xsl:key name="varMatch_Deposit" match="//deposit" use="."/>
<xsl:key name="varMatch_Withdrawal" match="//withdrawal" use="."/>

    <xsl:template match="/">

    <xsl:choose>
        <xsl:when test="$var_1 = 'deposit'">

            <xsl:for-each select="key('varMatch_Deposit', $var_2)">

                Deposit ID: <xsl:value-of select="@id"/><br/>
                Amount: <xsl:value-of select="."/><br/><br/><hr/>

            </xsl:for-each>

        </xsl:when>
        <xsl:when test="$var_1 = 'withdrawal'">

            <xsl:for-each select="key('varMatch_Withdrawal', $var_2)">

                Other ID: <xsl:value-of select="@id"/><br/>
                Other Amount: <xsl:value-of select="."/><br/><br/><hr/>

            </xsl:for-each>

        </xsl:when>
        <xsl:otherwise>

            //code for otherwise

        </xsl:otherwise>
    </xsl:choose>

    </xsl:template>
</xsl:stylesheet>


Hope this helps.

Best of luck!

M.David




----- Original Message ----- 
From: <aruniima(_dot_)chakrabarti(_at_)iflexsolutions(_dot_)com>
To: <xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com>
Sent: Monday, September 01, 2003 12:16 AM
Subject: [xsl] genarate key using a variable


Hi All,
Is it possible to generate a xsl:key using a variable ?
As in  xsl:key element it does not allow me to use a variable in either 
match or use attribute. So is there any other way to do the same...

e.g.
I want to search for all Rows with attribute say "@Deposit = 1"
where I receive both the attribute & the attribute value as parameters 
from the user.



Regards,
aruniima



DISCLAIMER:
This message contains privileged and confidential information and is 
intended only for the individual named.If you are not the intended 
recipient you should not disseminate,distribute,store,print, copy or 
deliver this message.Please notify the sender immediately by e-mail if you 
have received this e-mail by mistake and delete this e-mail from your 
system.E-mail transmission cannot be guaranteed to be secure or error-free 
as information could be intercepted,corrupted,lost,destroyed,arrive late 
or incomplete or contain viruses.The sender therefore does not accept 
liability for any errors or omissions in the contents of this message 
which arise as a result of e-mail transmission. If verification is 
required please request a hard-copy version.

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list



 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list




DISCLAIMER:
This message contains privileged and confidential information and is intended 
only for the individual named.If you are not the intended recipient you should 
not disseminate,distribute,store,print, copy or deliver this message.Please 
notify the sender immediately by e-mail if you have received this e-mail by 
mistake and delete this e-mail from your system.E-mail transmission cannot be 
guaranteed to be secure or error-free as information could be 
intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain 
viruses.The sender therefore does not accept liability for any errors or 
omissions in the contents of this message which arise as a result of e-mail 
transmission. If verification is required please request a hard-copy version.

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list



<Prev in Thread] Current Thread [Next in Thread>