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

Play the video

Subject: SQL SELECT statement in XSLT!!!!!!!!!!!!
From: "michel geadah" <m_ace_g@xxxxxxxxxxx>
Date: Wed, 06 Aug 2003 08:39:53 +0000

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

Current Thread
SQL SELECT statement in XSLT!!!!!!!!!!!! michel geadah - Wed, 6 Aug 2003 04:40:31 -0400 (EDT) <= <Possible follow-ups> Jeff Beadle - Wed, 6 Aug 2003 08:22:13 -0400 (EDT) Greg Johnson - Wed, 6 Aug 2003 10:40:46 -0400 (EDT) Américo Albuquerque - Wed, 6 Aug 2003 19:52:06 -0400 (EDT) Greg Johnson - Fri, 8 Aug 2003 16:57:21 -0400 (EDT)

<- Previous	Index	Next ->
RE: SQL SELECT statement in X, Michael Kay	Thread	RE: SQL SELECT statement in X, Jeff Beadle
Re: AW: Using key() from outs, David Carlisle	Date	RE: AW: Sorting Upper-Case fi, Mukul Gandhi
	Month

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

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >