cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christian Haul <h...@informatik.tu-darmstadt.de>
Subject Re: ESQL Update problem
Date Sun, 05 May 2002 16:00:46 GMT
sxk99c@Cs.Nott.AC.UK wrote:
> I have been developing an application for a few months now and up till
> now I haven't need to use the SQL UPDATE command, but when I added the
> code below to a logicsheet today...
> 
> <esql:execute-query>
>   <esql:query>UPDATE item set number='<xsp:expr>base.<xsl:value-of
> select="@type"/></xsp:expr>' where tech_id='<xsp:expr>tech</xsp:expr>'
> and player_id='<xsp:expr>player</xsp:expr>'</esql:query>
>   <esql:results>
>    <esql:row-results>
>     <update>update complete</update>
>    </esql:row-results>
>   </esql:results>
>  </esql:execute-query>
> 
> Cocoon seems to ignore the code? I don't think it is a cacheing problem
> as I emptied the work folder and re-tried it. It just appears to ignore
> the code. Can anyone help?

Please see my reply to Thomas von Schwerdtner "[esql] Nesting after 
INSERT..."
Basically, you want to use <esql:update-results/>

HTH
	Chris.


---------------------------------------------------------------------
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message