Montier Patrick wrote: >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"/>; > ... and </xsp:logic> here ;)
> > </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]> > --------------------------------------------------------------------- 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]>
