On 06.May.2002 -- 09:35 AM, Sharat Koya wrote:
> 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.
>
> 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/>
Just replace <esql:results/> with <esql:update-results/>.
Chris.
--
C h r i s t i a n H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
---------------------------------------------------------------------
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]>
