----- 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]>