|
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>
|
|
|