[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
i get a CURR_ISO empty tag...
How do i edit this so it would read from the table CURRENCIES and get the desired output???????????
_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
RE: [xsl] SQL SELECT statement in XSLT!!!!!!!!!!!!
Subject: RE: [xsl] SQL SELECT statement in XSLT!!!!!!!!!!!! From: "michel geadah" <m_ace_g@xxxxxxxxxxx> Date: Thu, 07 Aug 2003 07:07:56 +0000 |
When i put this: "<WACCTS> <curr_iso><xsl:value-of select="//CURRENCIES[mappings/curr_code=current()//ACCOUNTS/mappings/curr_co de]/mappings/curr_iso"/></curr_iso> </WACCTS>"
i get a CURR_ISO empty tag...
How do i edit this so it would read from the table CURRENCIES and get the desired output???????????
-----Original Message----- rom: michel geadah [mailto:m_ace_g@xxxxxxxxxxx] Sent: Wednesday, August 06, 2003 4:40 AM To: XSL-List@xxxxxxxxxxxxxxxxxxxxxx Subject: [xsl] SQL SELECT statement in XSLT!!!!!!!!!!!!
I have three tables:ACCOUNTS, WACCTS and CURRENCIES... In ACCOUNTS i have a field CURR_CODE but i do not have CURR_ISO field and In WACCTS i have a field CURR_ISO and In CURRENCIES i have both CURR_CODE and CURR_ISO
The tables are represented in XML like this:
<ACCOUNTS> <mappings> <curr_code>1234</curr_code> etc </mappings> <mappings> etc </mappings> </ACCOUNTS>
<CURRENCIES> <mappings> <curr_code>1234</curr_code> <curr_iso>12</curr_iso> etc </mappings> <mappings> etc </mappings> </CURRENCIES>
i want to write this select statement in XSLT:
"Select CURR_ISO from CURRENCIES where CURR_CODE(in ACCOUNTS)=CURR_CODE(in CURRENCIES)" AND THE OUTPUT OF THIS SELECT STATEMET I NEED TO PUT IT IN THE CURR_ISO OF WACCTS
i am using the ACCOUNTS table as the xml input to the saxon...
The WACCTS xml document is my output.(i.e i get the WACCTS xml document from
the saxon and fill in the WACCTS table).
THX...
_________________________________________________________________ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: RE: [xsl] SQL SELECT statement , cknell | Thread | RE: [xsl] SQL SELECT statement in X, Jeff Beadle |
[xsl] external function call, Peter_Ivan | Date | [xsl] declare xsl parameter, Lionel Crine |
Month |
Keywords