Well, esql:get-int needs a column name,
so try: "select count(*) as thecount from..."
and use: <esql:get-int column="thecount "/>
Olivier
-----Message d'origine-----
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%2F
cocoon/org/apache/cocoon/www/elenco/prova_xsp.java:4816: Invalid expression
statement. (_esql_query.resultset.getInt(1)) ^
How can I take the result?
---------------------------------------------------------------------
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
