[XSL-LIST Mailing List Archive Home] [By Thread] [By Date]

RE: [xsl] SQL SELECT statement in XSLT!!!!!!!!!!!!


Subject: RE: [xsl] SQL SELECT statement in XSLT!!!!!!!!!!!!
From: Jeff Beadle <Jbeadle@xxxxxxxx>
Date: Wed, 6 Aug 2003 08:22:28 -0400

<WACCTS>
   <curr_iso><xsl:value-of
select="//CURRENCIES[mappings/curr_code=current()//ACCOUNTS/mappings/curr_co
de]/mappings/curr_iso"/></curr_iso>
</WACCTS>


-----Original Message-----
From: 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



Current Thread
Keywords
xml