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