cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ba...@locus.apache.org
Subject cvs commit: xml-cocoon/samples/documents sql-page.xml.sql sql-page.xml
Date Fri, 31 Mar 2000 19:52:36 GMT
balld       00/03/31 11:52:35

  Modified:    samples/documents Tag: xml-cocoon2 sql-page.xml
  Added:       samples/documents Tag: xml-cocoon2 sql-page.xml.sql
  Log:
  Altered example to do nested query, added sql dump for test tables.
  
  Revision  Changes    Path
  No                   revision
  
  
  No                   revision
  
  
  1.1.2.2   +11 -8     xml-cocoon/samples/documents/Attic/sql-page.xml
  
  Index: sql-page.xml
  ===================================================================
  RCS file: /home/cvs/xml-cocoon/samples/documents/Attic/sql-page.xml,v
  retrieving revision 1.1.2.1
  retrieving revision 1.1.2.2
  diff -u -r1.1.2.1 -r1.1.2.2
  --- sql-page.xml	2000/03/22 07:36:45	1.1.2.1
  +++ sql-page.xml	2000/03/31 19:52:34	1.1.2.2
  @@ -7,19 +7,22 @@
    <!ELEMENT paragraph (#PCDATA)>
   ]>
   
  -<page>
  +<page
  +	xmlns:sql="http://xml.apache.org/cocoon/SQL"
  +>
    <title>Hello</title>
    <content>
     <paragraph>This is my first Cocoon2 page filled with sql data!</paragraph>
   
     <execute-query xmlns="http://xml.apache.org/cocoon/SQL"> 
  -   <query>select * from foo_table</query>
  -  </execute-query>
  -
  -  <execute-query xmlns="http://xml.apache.org/cocoon/SQL"> 
  -   <driver>org.gjt.mm.mysql.Driver</driver>
  -   <dburl>jdbc:mysql://localhost/test</dburl>
  -   <query>select * from foo_table</query>
  +   <query>
  +   	select id,name from department_table
  +   </query>
  +	<execute-query>
  +	 <query>
  +	  select id,name from employee_table where department_id = <ancestor-value sql:name="id"
sql:level="1"/>
  +	 </query>
  +	</execute-query>
     </execute-query>
   
    </content>
  
  
  
  No                   revision
  
  
  No                   revision
  
  
  1.1.2.1   +39 -0     xml-cocoon/samples/documents/Attic/sql-page.xml.sql
  
  
  
  

Mime
View raw message