----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 05, 2002 5:09 PM
Subject: ESQL Update problem
> 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?
>
maybe you have to wrap the execute query tag inside:
<esql:connection>
<esql:pool>personnel</esql:pool>
<esql:autocommit>false</esql:autocommit>
....
<esql:connection>
.
hope this helps.
pino
> Sharat Koya
> WinXP, MySQL 3.23, cocoon 2.02, Java 1.3
>
>
> ---------------------------------------------------------------------
> 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]>
