[EMAIL PROTECTED] 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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
