Help using XSP + ESQL to generate a xml query file

[yann petit <yp...@capgemini.fr>]

Hello,


I've got a XML file, taking some arguments and using xsp:logic to generate it's own content depending on these arguments.
In this content I do <esql:query> with my arguments as parameters....
But This doesn't work !

It seems that while in a <esql:query> the values of my <xsp:logic> variables are not known anymore.
How can I do that ?
Any ideas ?

Thank you for any help

Yann


See below my xml file :
See attachements for the .java file


************************************************************************************************************************


<?xml version="1.0"?>
<?cocoon-process type="xsp"?>
<?cocoon-format type="text/xml"?>
<?xml-logicsheet href="resource://org/apache/cocoon/processor/xsp/library/sql/esql.xsl"?>
<xsp:page language="java" xmlns:xsp="http://www.apache.org/1999/XSP/Core" xmlns:request="http://www.apache.org/1999/XSP/Request" xmlns:esql="http://apache.org/cocoon/SQL/v2">
 <root>
  <page>
   <xsp:logic>Enumeration enum = request.getParameterNames();
while (enum.hasMoreElements()) {
  String parameterName = (String) enum.nextElement();
  String[] parameterValues = request.getParameterValues(parameterName);
  for (int i = 0; i &lt; parameterValues.length; i++) {
    <tache>
     <query>
     <test><xsp:expr>parameterValues[i]</xsp:expr></test>
       <esql:execute-query>
        <esql:driver>sun.jdbc.odbc.JdbcOdbcDriver</esql:driver>
        <esql:dburl>jdbc:odbc:tsd</esql:dburl>
        <esql:query>SELECT Task_LIB FROM TASKS WHERE Task_ID = '<xsp:expr>parameterValues[i]</xsp:expr>'</esql:query>
        <esql:results>
         <result>
          <Task_LIB>
           <esql:get-string column="Task_LIB"/>
          </Task_LIB>
         </result>
        </esql:results>
       </esql:execute-query>
     </query>
    </tache>
  }
}
   </xsp:logic>
  </page>
 </root>
</xsp:page>

**********************************************************************************************************************************

java.lang.Exception: XSP Java Compiler: Compilation failed for _nTasksForYohann_testsYann3.java
100: Undefined variable: parameterValues

						+ parameterValues[i]

						  ^

100: Undefined variable: i

						+ parameterValues[i]

						                  ^

2 errors



	at org.apache.cocoon.processor.xsp.language.java.XSPJavaProcessor.compile(XSPJavaProcessor.java, Compiled Code)
	at java.lang.Exception.(Exception.java, Compiled Code)
	at org.apache.cocoon.processor.xsp.language.java.XSPJavaProcessor.compile(XSPJavaProcessor.java, Compiled Code)
	at org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java, Compiled Code)
	at org.apache.cocoon.Engine.handle(Engine.java, Compiled Code)
	at org.apache.cocoon.Cocoon.service(Cocoon.java, Compiled Code)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java, Compiled Code)
	at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java, Compiled Code)
	at org.apache.tomcat.core.ContextManager.service(ContextManager.java, Compiled Code)
	at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java, Compiled Code)
	at org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java, Compiled Code)
	at java.lang.Thread.run(Thread.java, Compiled Code)