esql problem

[Marco Spinetti]

Hi all, I have a question about esql. In my application I do a query "select count(*) from....." and I try to get the number result in this way:   <esql:connection>     <esql:pool>elenco1</esql:pool>     <esql:execute-query>      <esql:query><xsp:expr>query</xsp:expr></esql:query>      <esql:results>      <esql:row-results>      rowNum = <esql:get-int column="1"/>;      </esql:row-results>      </esql:results>      </esql:execute-query>     </esql:connection>     but cocoon2 gives me a error:   Invalid expression statement. (_esql_query.resultset.getInt(1)) ^ Line 0, column 0: /usr/local/home/siteadm/download/jakarta-tomcat-3.2.2/work/localhost_8080%2Fcocoon/org/apache/cocoon/www/elenco/prova_xsp.java:4816: Invalid expression statement. (_esql_query.resultset.getInt(1)) ^   How can I take the result? Help me Marco   +---------------------------------------------------------------+ Data processing engineer  Spinetti Marco Italia On Line S.p.a. - Infostrada Italy +-----------------------------------------------------------------+