[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
[Recent Entries]
[Reply To This Message]
RE: SQL SELECT statement in XSLT!!!!!!!!!!!!
Subject: RE: 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: 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 |
cknell - Wed, 6 Aug 2003 11:21:58 -0400 (EDT)
michel geadah - Thu, 7 Aug 2003 03:08:34 -0400 (EDT) <=
Jeff Beadle - Thu, 7 Aug 2003 07:19:16 -0400 (EDT)
michel geadah - Fri, 8 Aug 2003 03:23:03 -0400 (EDT)
|
|
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format
RSS 2.0 |
|
Atom 0.3 |
|
|