hi,
Your Mysql connexion (here Mybase) must be declared in the cocoon.xconf and
web.xml.
Here is an simple example :
<xsp:logic>
int idemp=0;
</xsp:logic>
<esql:connection>
<esql:pool>Mybase</esql:pool>
<bestof>
<esql:execute-query>
<esql:query>
SELECT * from mytable
</esql:query>
<esql:results>
<esql:row-results>
<row>
<xsp:logic>
idemp=<esql:get-int column="id_emp"/>;
</esql:row-results>
</esql:results>
<esql:no-results>No results</esql:no-results>
<esql:error-results>
<sqlerr><esql:get-message/></sqlerr>
</esql:error-results>
</esql:execute-query>
</bestof>
</esql:connection>
Patrick
-----Message d'origine-----
De : Bobby Koya [mailto:[EMAIL PROTECTED]]De la part de
[EMAIL PROTECTED]
Envoyé : mercredi 3 avril 2002 18:00
À : [EMAIL PROTECTED]
Objet : esql and xsp:logic
Hi I have a problem with some logic. The problem is that I have some
data stored in a mysql database and I would like to use this data in an
XSP file. Eg:
<esql> grab the data </esql>
<xsp:logic>
start to use the data.
</xsp:logic>
Am I correct that this is not possible because the xsp:logic statements
are done before the esql statements or is it possible to do this:
<xsp:logic>
<esql> grab the data </esql>
start to use the data.
</xsp:logic>
Thanks for your time,
Sharat Koya
---------------------------------------------------------------------
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]>
