xsl-list
[Top] [All Lists]

SQL SELECT statement in XSLT!!!!!!!!!!!!

2003-08-06 01:39:53
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