<?xml version="1.0" encoding="ISO-8859-1"?>
<?cocoon-process type="xsp"?>
<?cocoon-process type="xslt"?>
<?xml-stylesheet href="portal.xsl" type="text/xsl"?>


<!-- DOCTYPE page SYSTEM "portal.dtd" -->

<xsp:page
  language="java"
  xmlns:xsp="http://www.apache.org/1999/XSP/Core"
  xmlns:esql="http://apache.org/cocoon/SQL/v2"
>

 <page>

 <esql:connection>
  <esql:driver>org.gjt.mm.mysql.Driver</esql:driver>
  
  <esql:dburl>jdbc:mysql://tecfa.unige.ch/radeff</esql:dburl>
  <esql:username>nobody</esql:username>
  <esql:password></esql:password>
  <top>
   <logo src="http://tecfa.unige.ch/gif/server/tecfa-small-wb30.gif" alt="TECFA"/>
   <title>TECFA's Portal</title>
  </top>
  
  <left>
   <box>
    <title>Sauces</title>
    <intro>The 1st and Scd sauce</intro>
    <list>
     <el>
     </el>
     <el>
      <title></title>
      <description>
      </description>
      <date></date>
  <url xml:link="locator" href="http://tecfa.unige.ch/staf/staf-f/radeff/staf14/ex5/recette.sxml" title="Aioli">Follow that xml-link</url>
 </el>
 </list>
 </box>
 </left>
  
  <middle> 
   <box>
    <title>New</title>
    <intro></intro>
    <list>
  <esql:execute-query>
   <esql:query>SELECT * FROM recettes ORDER BY dateEntree DESC;</esql:query>
   <esql:results>
    <esql:row-results>
     
     <el>
      <title><esql:get-string column="dateEntree"/></title>
     <url><esql:get-string column="url"/></url>
    </el>
     
    </esql:row-results>
   </esql:results>
  </esql:execute-query>
  
 </list>
</box>
</middle>
 
 <right>
  <box>
   <title>Cooking</title>
   <intro>Receipes</intro>
   <list>
    
 <esql:execute-query>
  <esql:query>SELECT * FROM recettes ORDER BY Titre;</esql:query>
  <esql:results>
   <esql:row-results>
    <el>
     <title><esql:get-string column="Titre"/></title>
    <url><esql:get-string column="url"/></url>
   </el>
   </esql:row-results>
  </esql:results>
 </esql:execute-query>
</list>
 
</box>
</right>
</esql:connection>
</page>
</xsp:page>

