Sorry but could you give me the full bit of code from esql:execute-query, I can't get my head around it and I couldn't find much documentation on how to use it.
-----Original Message----- From: Christian Haul [mailto:[EMAIL PROTECTED]] Sent: Sunday, 05 May 2002 17:01 To: [EMAIL PROTECTED] Subject: Re: ESQL Update problem [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]> --------------------------------------------------------------------- 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]>