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 >>> [EMAIL PROTECTED] 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 [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. MailScanner thanks transtec Computers for their support. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
