You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by java guru <ja...@yahoo.co.in> on 2001/06/18 18:45:35 UTC

using esql without xsp

Hi.,
   I am newbie to cocoon and trying the example to use
esql without xsp..following is the xml i am trying to
put
. But how shall i mention this to sitemap? what
generator/transformer/serializer need to be included


Thanks

******************************************************
<?xml version="1.0" encoding="ISO-8859-1"?>

  <page xmlns:esql="http://apache.org/cocoon/SQL/v2">

   <title>A Database Driven XSP Page</title>

   <content>

   <esql:connection>
     <esql:pool>personnel</esql:pool>
     <esql:username>sa</esql:username>
     <esql:password></esql:password>
     <esql:execute-query>
       <esql:query>select * from
department_table</esql:query>
       <esql:results>
         <esql:row-results>
           <para><esql:get-string
column="name"/></para>
           <esql:get-columns/>
         </esql:row-results>
       </esql:results>
     </esql:execute-query>
     <esql:execute-query>
       <esql:query>select xml from
xml_table</esql:query>
       <esql:results>
         <esql:row-results>
           <esql:get-xml column="xml"/>
         </esql:row-results>
       </esql:results>
     </esql:execute-query>
   </esql:connection>

   </content>
  </page>
**************************************************

____________________________________________________________
Do You Yahoo!?
For regular News updates go to http://in.news.yahoo.com

---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>