Hi Oliver,
I tried what you suggest but the error is the same:
org.apache.cocoon.ProcessingException: Failed to execute
pipeline.:org.apache.cocoon.ResourceNotFoundException: Language
Exception:org.apache.cocoon.ProcessingException: Language
Exception:org.apache.cocoon.components.language.LanguageException: Error
compiling prova_xsp: 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:1319: Invalid expression
statement. (_esql_query.resultset.getInt("pippo")) ^ 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:3083: Invalid expression
statement. (_esql_query.resultset.getInt("pippo")) ^ 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("pippo")) ^
Any ideas?
What can I do?
Thanks
marco
----- Original Message -----
From: JEULIN Olivier <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 06, 2001 2:30 PM
Subject: RE: esql problem
> 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]>
>
>
---------------------------------------------------------------------
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]>
