[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: SQL SELECT statement in XSLT!!!!!!!!!!!!
<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: 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
|
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
|