Hi
You should have a datatype :
<xsp:logic>int aa=<esql:get-int column="id_rst"/>;</xsp:logic>
<xsp:expr>aa</xsp:expr>
Lionel
Franco Andrao a ecrit le 1/07/05 10:31:
Hi,
I'm developing a web application with esql in a xsp page following the
wiki page HowToCreateHiearchicalXmlUsingESQL. Therefore assigning a
value to a variable inside the esql:row-results I have this error:
org.apache.cocoon.ProcessingException: Language Exception:
org.apache.cocoon.components.language.LanguageException: Error
compiling page_xsp: ERROR 1
(org/apache/cocoon/www/presentation/xml/page_xsp.java): ... do {
this.characters("\n\t\t\t\t\t"); // start error (lines 461-461) "aa
cannot be resolved" aa= // end error (
EsqlHelper.getAscii(_esql_query.getResultSet(),"id_rst","") ) ...
ERROR 2 (org/apache/cocoon/www/presentation/xml/page_xsp.java): ...
this.characters("\n\t\t\t\t\t"); aa= ( // start error (lines 464-464)
"Invalid cast type expression"
EsqlHelper.getAscii(_esql_query.getResultSet(),"id_rst","") // end
error ) this.characters("\n\t\t\t\t\t"); ... Line 461, column 0: aa
cannot be resolved Line 464, column 0: Invalid cast type expression
the simple xsp test page I'm using is below and without the xsp:logic
work perfectly:
<?xml version="1.0"?>
<xsp:page language="java"
xmlns:xsp="http://apache.org/xsp";
xmlns:xsp-request="http://apache.org/xsp/request/2.0";
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
xmlns:esql="http://apache.org/cocoon/SQL/v2";>
<page>
<esql:connection>
<esql:pool>myDB</esql:pool>
<esql:execute-query>
<esql:query>
SELECT * FROM mytab
WHERE id_rst=4
</esql:query>
<esql:results>
<esql:row-results>
<xsp:logic>aa=<esql:get-int
column="id_rst"/>;</xsp:logic>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
</page>
</xsp:page>
Thanks
Best regards
*:-)Franco Andrao*
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>_
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
