cocoon-cvs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From cziege...@apache.org
Subject cvs commit: xml-cocoon2/xdocs esql.xml sitemap.xml
Date Mon, 09 Jul 2001 12:47:08 GMT
cziegeler    01/07/09 05:47:08

  Modified:    xdocs    esql.xml sitemap.xml
  Log:
  Applied docs patch contributed by Torsten Curdt.
  
  Revision  Changes    Path
  1.3       +27 -2     xml-cocoon2/xdocs/esql.xml
  
  Index: esql.xml
  ===================================================================
  RCS file: /home/cvs/xml-cocoon2/xdocs/esql.xml,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- esql.xml	2001/06/14 14:07:15	1.2
  +++ esql.xml	2001/07/09 12:47:04	1.3
  @@ -17,8 +17,8 @@
   
       <p>It has a number of important advantages over the old (deprecated) SQL logicsheet
and SQL processor.
        For example, it allows you to mix esql with other logicsheets. It also
  -     supports prepared statements (which gives you automatic parameter escaping) - and
even multiple encodings
  -     in a single query!</p>
  +     supports prepared statements (which gives you automatic parameter escaping), multiple
encodings
  +     in a single query and even multiple resultsets on one statement (if supported from
database)!</p>
   
       <p>The name was chosen merely to emphasise the fact that this is an extended
version of the old sql logicsheet -
          esql still uses standard SQL syntax. In fact, it is just a conversion wrapper around
your JDBC database
  @@ -62,6 +62,31 @@
             written in the W3C standard language XML Schema, of every single esql element
and attribute.
             It is fairly human-readable and includes comments for the purpose of each tag.</p>
   
  +          <p>A fairly common example is to list a query result in a table. Notice
that esql:results and esql:no-results
  +          are mutual exclusive. So only one of them will be in your XML tree. This example
takes a connection from a
  +          datasource defined in <code>cocoon.xconf</code>:</p>
  +
  +          <source><![CDATA[
  +<esql:connection>
  +  <esql:pool>connectionName</esql:pool>
  +  <esql:execute-query>
  +    <esql:query>SELECT mycolumn1,mycolumn2 FROM table</esql:query>
  +    <esql:results>
  +      <table>
  +        <esql:row-results>
  +          <tr>
  +             <td><esql:get-string column="mycolumn1"/></td>
  +             <td><esql:get-string column="mycolumn2"/></td>
  +          </tr>
  +        </esql:row-results>
  +      </table>
  +    </esql:results>
  +    <esql:no-results>
  +       <p>Sorry, no results!</p>
  +    </esql:no-results>
  +  </esql:execute-query>
  +</esql:connection>]]>
  +</source>
             <p>The ultimate reference, is of course the source code, which is an XSLT
logicsheet contained in the
             file <code>src/org/apache/cocoon/components/language/markup/xsp/java/esql.xsl</code></p>
   
  
  
  
  1.2       +6 -6      xml-cocoon2/xdocs/sitemap.xml
  
  Index: sitemap.xml
  ===================================================================
  RCS file: /home/cvs/xml-cocoon2/xdocs/sitemap.xml,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- sitemap.xml	2001/05/09 20:50:23	1.1
  +++ sitemap.xml	2001/07/09 12:47:05	1.2
  @@ -253,12 +253,12 @@
          <map:serializers default="html">
           <map:serializer type="html" mime-type="text/html" 
             src="class:///org.apache.cocoon.serializer.HTMLSerializer">
  -         <doctype-public value="-//W3C//DTD HTML 4.0 Transitional//EN"/>
  -         <doctype-system value="http://www.w3.org/TR/REC-html40/loose.dtd"/>
  -         <preserve-space value="true"/>
  -         <encoding value="UTF-8"/>
  -         <indent value="1"/>
  -         <line-width value="120"/>
  +         <doctype-public>-//W3C//DTD HTML 4.0 Transitional//EN</doctype-public>
  +         <doctype-system>http://www.w3.org/TR/REC-html40/loose.dtd</doctype-system>
  +         <preserve-space>true</preserve-space>
  +         <encoding>UTF-8</encoding>
  +         <indent>1</indent>
  +         <line-width>120</line-width>
           </map:serializer>
   
           <map:serializer type="wap" mime-type="text/vnd.wap.wml" 
  
  
  

----------------------------------------------------------------------
In case of troubles, e-mail:     webmaster@xml.apache.org
To unsubscribe, e-mail:          cocoon-cvs-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-cvs-help@xml.apache.org


Mime
View raw message