| 
 CGI ERROR <?xml version="1.0" encoding="ISO-8859-1"?> <xsp:page language="java" xmlns:xsp="http://apache.org/xsp" xmlns:esql="http://apache.org/cocoon/SQL/v2" > <page> <esql:connection> <esql:pool>hb_pool</esql:pool> <transactions> <esql:execute-query> <esql:skip-rows>2</esql:skip-rows> <esql:max-rows>5</esql:max-rows> <esql:query> select * from srv_trans where acc_num = 0180698943 order by trans_date </esql:query> <esql:results> <esql:row-results> <trans> <xsp:attribute name="no"> <xsp:expr> <esql:get-row-position/>+1</xsp:expr> </xsp:attribute> <id> <esql:get-int column="trans_id1"/> </id> <date> <esql:get-date column="trans_date" format="dd. MMM. yyyy"/> </date> <account> <esql:get-string column="acc_num"/> </account> <amount> <esql:get-double column="amount"/> </amount> <currency> <esql:get-string column="curr"/> </currency> </trans> </esql:row-results> </esql:results> <esql:no-results> No records found... </esql:no-results> <esql:error-results> SQL Exception: <esql:get-message/> </esql:error-results> </esql:execute-query> </transactions> </esql:connection> </page> </xsp:page>    <?xml version="1.0" encoding="UTF-8"?>
   <page xmlns:xspdoc="http://apache.org/cocoon/XSPDoc/v1"
     xmlns:esql="http://apache.org/cocoon/SQL/v2"
     xmlns:xsp="http://apache.org/xsp">
     <transactions>          
       <transaction no="1">
         <id>444</id>
         <date>31. mar. 2001</date>
         <account>0180698943</account>
         <amount>-10.0</amount>
         <currency>SKK</currency>
       </transaction>          
       <transaction no="2">
         <id>344</id>
         <date>30. apr. 2001</date>
         <account>0180698943</account>
         <amount>-10.0</amount>
         <currency>SKK</currency>
       </transaction>
       <transaction no="3">
         <id>141</id>
         <date>31. maj. 2001</date>
         <account>0180698943</account>
         <amount>-10.0</amount>
         <currency>SKK</currency>
       </transaction>   
       <transaction no="4">
         <id>849</id>
         <date>30. jun. 2001</date>
         <account>0180698943</account>
         <amount>-10.0</amount>
         <currency>SKK</currency>
       </transaction>
       <transaction no="5">
         <id>4329</id>
         <date>31. jul. 2001</date>
         <account>0180698943</account>
         <amount>-10.0</amount>
         <currency>SKK</currency>
       </transaction>
     </transactions>
   </page>
 | 
 | 
| 
 |