Subject: Detail tables handled in XSLT, XSQL, ORACLE From: "Rob Jagelski" <rjagelski@xxxxxxxxxxx> Date: Mon, 30 Oct 2000 14:38:05 -0400 (EST) |
***** <?xml version = '1.0'?> <ROWSET xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xsl:version="1.0">
<ROW> <DEPTNO><xsl:value-of select="DEPTNO"/></DEPTNO> <DNAME><xsl:value-of select="DNAME"/></DNAME> <LOC><xsl:value-of select="LOC"/></LOC> <xsl:for-each select="EMPLOYEES/EMPLOYEES_ITEM"> <EMPLOYEES>emp_list(emp_t(<xsl:value-of select="EMPNO"/> <xsl:value-of select="ENAME"/> <xsl:value-of select="SAL"/>))</EMPLOYEES> </xsl:for-each> </ROW>
</ROWSET> *****
<ROWSET> <ROW> <DEPTNO>99</DEPTNO> <DNAME>ACCOUNTING</DNAME> <LOC>NEW YORK</LOC> <EMPLOYEES> <EMPLOYEES_ITEM> <EMPNO>1111</EMPNO> <ENAME>CLARK</ENAME> <SAL>2450</SAL> </EMPLOYEES_ITEM> <EMPLOYEES_ITEM> <EMPNO>2222</EMPNO> <ENAME>KING</ENAME> <SAL>5000</SAL> </EMPLOYEES_ITEM> <EMPLOYEES_ITEM> <EMPNO>3333</EMPNO> <ENAME>MILLER</ENAME> <SAL>1300</SAL> </EMPLOYEES_ITEM> </EMPLOYEES> </ROW> </ROWSET> *****
<?xml version='1.0'?> <xsql:insert-request connection="rob" xmlns:xsql="urn:oracle-xsql" table="department" transform="address_insert2.xsl"/> *****
Thanks so much, Rob
_________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
DOCTYPE, Rainer . Jung | Thread | Re: Detail tables handled in XSLT, , Steve Muench |
Re: Error Gen'ing XML from HTML, David Carlisle | Date | Re: child and descendant: what is t, David Carlisle |
Month |