cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Olivier Billard <obill...@jouve.fr>
Subject Re: XSP : store the result of the ESQL query
Date Tue, 18 May 2004 08:39:01 GMT
Hi Derek,

No idea : never used both.
But a made a double knot to my little finger, for reminding me to have a 
look at JXTemplate.

Derek Hohls wrote:
> And as a side issue - given that many developers eschew
> the use of XSP (exactly because it does logic calculations
> as shown in your example) - is it possible to reproduce
> this type of approach using, say, JXTemplates and the
> SQLTransformer...
> 
> Thanks
> Derek
> 
> 
>>>>obillard@jouve.fr 2004/05/18 09:49:42 AM >>>
> 
> Hi homonym,
> 
> This solution works "if it works" !
> But if the first query fails, you'll get an unexpected result for the 
> second query if maxpos is not initialized...
> Remember that queries can be embedded in each other :
> 
> sql = "SELECT rub_position FROM m_rub_player_ope WHERE player_url_name
> = 
> '"+player_url_name+"' ORDER BY rub_position LIMIT 1";
> <esql:connection>
> <esql:pool>my_pool</esql:pool>
> <esql:execute-query>
> <esql:query><xsp:expr>sql</xsp:expr></esql:query>
> <esql:results>
> <esql:row-results>
> <xsp:logic>
> maxpos = <esql:get-int column="rub_position"/>;
> maxpos = maxpos + 10;
> 
> <esql:execute-query>
> <esql:query>
> INSERT INTO m_rub_player_ope 
> (rub_id,player_url_name,ope_url_name,rub_display,rub_position)
> VALUES (
> <esql:parameter
> type="string"><xsp:expr>rub_id</xsp:expr></esql:parameter>,
> <esql:parameter 
> type="string"><xsp:expr>player_url_name</xsp:expr></esql:parameter>,
> <esql:parameter 
> type="string"><xsp:expr>ope_url_name</xsp:expr></esql:parameter>,
> <esql:parameter type="string">oui</esql:parameter>,
> '<xsp:expr>maxpos</xsp:expr>');
> </esql:query>
> <esql:error-results><message>Error during 
> Insert</message></esql:error-results>
> <esql:update-results>
> <esql:get-update-count/><message continuer="do-list-rub.html">Your 
> record is adding ya can click on </message>
> </esql:update-results>
> </esql:execute-query>
> 
> </xsp:logic>
> </esql:row-results>
> </esql:results>
> </esql:execute-query>
> <esql:error-results>
>    // deal with errors here
> </esql:error-results>
> </esql:connection>
> 
> HTH,
> --
> Olivier Billard
> 
> 
> olivier demah wrote:
> 
>>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";
>><esql:connection>
>><esql:pool>my_pool</esql:pool>
>><esql:execute-query>
>><esql:query><xsp:expr>sql</xsp:expr></esql:query>
>><esql:results>
>><esql:row-results>
>><xsp:logic>
>>maxpos = <esql:get-int column="rub_position"/>;
>>maxpos = maxpos + 10;
>></xsp:logic>
>></esql:row-results>
>></esql:results>
>></esql:execute-query>
>><esql:execute-query>
>><esql:query>
>>INSERT INTO m_rub_player_ope 
>>(rub_id,player_url_name,ope_url_name,rub_display,rub_position)
>>VALUES (
>><esql:parameter
> 
> type="string"><xsp:expr>rub_id</xsp:expr></esql:parameter>,
> 
>><esql:parameter 
>>type="string"><xsp:expr>player_url_name</xsp:expr></esql:parameter>,
>><esql:parameter 
>>type="string"><xsp:expr>ope_url_name</xsp:expr></esql:parameter>,
>><esql:parameter type="string">oui</esql:parameter>,
>>'<xsp:expr>maxpos</xsp:expr>');
>></esql:query>
>><esql:error-results><message>Error during 
>>Insert</message></esql:error-results>
>><esql:update-results>
>><esql:get-update-count/><message continuer="do-list-rub.html">Your 
>>record is adding ya can click on </message>
>></esql:update-results>
>></esql:execute-query>
>></esql:connection>
>>
>>thanks to steve_k on #cocoon@freenode.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message