cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From olivier demah <>
Subject Re: XSP : store the result of the ESQL query
Date Wed, 12 May 2004 14:46:11 GMT
olivier demah a e'crit :

> Hi,
> i would like to know if i can store the result of an ESQL query in a 
> variable to be reused in another ESQL query later in the same XSP ?
> regards

here is the solution :

sql = "SELECT rub_position FROM m_rub_player_ope WHERE player_url_name = 
'"+player_url_name+"' ORDER BY rub_position LIMIT 1";
maxpos = <esql:get-int column="rub_position"/>;
maxpos = maxpos + 10;
INSERT INTO m_rub_player_ope 
<esql:parameter type="string"><xsp:expr>rub_id</xsp:expr></esql:parameter>,
<esql:parameter type="string">oui</esql:parameter>,
<esql:error-results><message>Error during 
<esql:get-update-count/><message continuer="do-list-rub.html">Your 
record is adding ya can click on </message>

thanks to steve_k on #cocoon@freenode.

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message